package com.crm.model.entity.contractManager;

import java.util.ArrayList;
import java.util.Date;
import java.util.List;

public class ContractRawDataExample {
    protected String orderByClause;

    protected boolean distinct;

    protected List<Criteria> oredCriteria;

    public ContractRawDataExample() {
        oredCriteria = new ArrayList<>();
    }

    public void setOrderByClause(String orderByClause) {
        this.orderByClause = orderByClause;
    }

    public String getOrderByClause() {
        return orderByClause;
    }

    public void setDistinct(boolean distinct) {
        this.distinct = distinct;
    }

    public boolean isDistinct() {
        return distinct;
    }

    public List<Criteria> getOredCriteria() {
        return oredCriteria;
    }

    public void or(Criteria criteria) {
        oredCriteria.add(criteria);
    }

    public Criteria or() {
        Criteria criteria = createCriteriaInternal();
        oredCriteria.add(criteria);
        return criteria;
    }

    public Criteria createCriteria() {
        Criteria criteria = createCriteriaInternal();
        if (oredCriteria.size() == 0) {
            oredCriteria.add(criteria);
        }
        return criteria;
    }

    protected Criteria createCriteriaInternal() {
        Criteria criteria = new Criteria();
        return criteria;
    }

    public void clear() {
        oredCriteria.clear();
        orderByClause = null;
        distinct = false;
    }

    protected abstract static class GeneratedCriteria {
        protected List<Criterion> criteria;

        protected GeneratedCriteria() {
            super();
            criteria = new ArrayList<>();
        }

        public boolean isValid() {
            return criteria.size() > 0;
        }

        public List<Criterion> getAllCriteria() {
            return criteria;
        }

        public List<Criterion> getCriteria() {
            return criteria;
        }

        protected void addCriterion(String condition) {
            if (condition == null) {
                throw new RuntimeException("Value for condition cannot be null");
            }
            criteria.add(new Criterion(condition));
        }

        protected void addCriterion(String condition, Object value, String property) {
            if (value == null) {
                throw new RuntimeException("Value for " + property + " cannot be null");
            }
            criteria.add(new Criterion(condition, value));
        }

        protected void addCriterion(String condition, Object value1, Object value2, String property) {
            if (value1 == null || value2 == null) {
                throw new RuntimeException("Between values for " + property + " cannot be null");
            }
            criteria.add(new Criterion(condition, value1, value2));
        }

        public Criteria andContractRawDataIdIsNull() {
            addCriterion("contract_raw_data_id is null");
            return (Criteria) this;
        }

        public Criteria andContractRawDataIdIsNotNull() {
            addCriterion("contract_raw_data_id is not null");
            return (Criteria) this;
        }

        public Criteria andContractRawDataIdEqualTo(String value) {
            addCriterion("contract_raw_data_id =", value, "contractRawDataId");
            return (Criteria) this;
        }

        public Criteria andContractRawDataIdNotEqualTo(String value) {
            addCriterion("contract_raw_data_id <>", value, "contractRawDataId");
            return (Criteria) this;
        }

        public Criteria andContractRawDataIdGreaterThan(String value) {
            addCriterion("contract_raw_data_id >", value, "contractRawDataId");
            return (Criteria) this;
        }

        public Criteria andContractRawDataIdGreaterThanOrEqualTo(String value) {
            addCriterion("contract_raw_data_id >=", value, "contractRawDataId");
            return (Criteria) this;
        }

        public Criteria andContractRawDataIdLessThan(String value) {
            addCriterion("contract_raw_data_id <", value, "contractRawDataId");
            return (Criteria) this;
        }

        public Criteria andContractRawDataIdLessThanOrEqualTo(String value) {
            addCriterion("contract_raw_data_id <=", value, "contractRawDataId");
            return (Criteria) this;
        }

        public Criteria andContractRawDataIdLike(String value) {
            addCriterion("contract_raw_data_id like", value, "contractRawDataId");
            return (Criteria) this;
        }

        public Criteria andContractRawDataIdNotLike(String value) {
            addCriterion("contract_raw_data_id not like", value, "contractRawDataId");
            return (Criteria) this;
        }

        public Criteria andContractRawDataIdIn(List<String> values) {
            addCriterion("contract_raw_data_id in", values, "contractRawDataId");
            return (Criteria) this;
        }

        public Criteria andContractRawDataIdNotIn(List<String> values) {
            addCriterion("contract_raw_data_id not in", values, "contractRawDataId");
            return (Criteria) this;
        }

        public Criteria andContractRawDataIdBetween(String value1, String value2) {
            addCriterion("contract_raw_data_id between", value1, value2, "contractRawDataId");
            return (Criteria) this;
        }

        public Criteria andContractRawDataIdNotBetween(String value1, String value2) {
            addCriterion("contract_raw_data_id not between", value1, value2, "contractRawDataId");
            return (Criteria) this;
        }

        public Criteria andContractCreateTmIsNull() {
            addCriterion("contract_create_tm is null");
            return (Criteria) this;
        }

        public Criteria andContractCreateTmIsNotNull() {
            addCriterion("contract_create_tm is not null");
            return (Criteria) this;
        }

        public Criteria andContractCreateTmEqualTo(String value) {
            addCriterion("contract_create_tm =", value, "contractCreateTm");
            return (Criteria) this;
        }

        public Criteria andContractCreateTmNotEqualTo(String value) {
            addCriterion("contract_create_tm <>", value, "contractCreateTm");
            return (Criteria) this;
        }

        public Criteria andContractCreateTmGreaterThan(String value) {
            addCriterion("contract_create_tm >", value, "contractCreateTm");
            return (Criteria) this;
        }

        public Criteria andContractCreateTmGreaterThanOrEqualTo(String value) {
            addCriterion("contract_create_tm >=", value, "contractCreateTm");
            return (Criteria) this;
        }

        public Criteria andContractCreateTmLessThan(String value) {
            addCriterion("contract_create_tm <", value, "contractCreateTm");
            return (Criteria) this;
        }

        public Criteria andContractCreateTmLessThanOrEqualTo(String value) {
            addCriterion("contract_create_tm <=", value, "contractCreateTm");
            return (Criteria) this;
        }

        public Criteria andContractCreateTmLike(String value) {
            addCriterion("contract_create_tm like", value, "contractCreateTm");
            return (Criteria) this;
        }

        public Criteria andContractCreateTmNotLike(String value) {
            addCriterion("contract_create_tm not like", value, "contractCreateTm");
            return (Criteria) this;
        }

        public Criteria andContractCreateTmIn(List<String> values) {
            addCriterion("contract_create_tm in", values, "contractCreateTm");
            return (Criteria) this;
        }

        public Criteria andContractCreateTmNotIn(List<String> values) {
            addCriterion("contract_create_tm not in", values, "contractCreateTm");
            return (Criteria) this;
        }

        public Criteria andContractCreateTmBetween(String value1, String value2) {
            addCriterion("contract_create_tm between", value1, value2, "contractCreateTm");
            return (Criteria) this;
        }

        public Criteria andContractCreateTmNotBetween(String value1, String value2) {
            addCriterion("contract_create_tm not between", value1, value2, "contractCreateTm");
            return (Criteria) this;
        }

        public Criteria andCompanyIsNull() {
            addCriterion("company is null");
            return (Criteria) this;
        }

        public Criteria andCompanyIsNotNull() {
            addCriterion("company is not null");
            return (Criteria) this;
        }

        public Criteria andCompanyEqualTo(String value) {
            addCriterion("company =", value, "company");
            return (Criteria) this;
        }

        public Criteria andCompanyNotEqualTo(String value) {
            addCriterion("company <>", value, "company");
            return (Criteria) this;
        }

        public Criteria andCompanyGreaterThan(String value) {
            addCriterion("company >", value, "company");
            return (Criteria) this;
        }

        public Criteria andCompanyGreaterThanOrEqualTo(String value) {
            addCriterion("company >=", value, "company");
            return (Criteria) this;
        }

        public Criteria andCompanyLessThan(String value) {
            addCriterion("company <", value, "company");
            return (Criteria) this;
        }

        public Criteria andCompanyLessThanOrEqualTo(String value) {
            addCriterion("company <=", value, "company");
            return (Criteria) this;
        }

        public Criteria andCompanyLike(String value) {
            addCriterion("company like", value, "company");
            return (Criteria) this;
        }

        public Criteria andCompanyNotLike(String value) {
            addCriterion("company not like", value, "company");
            return (Criteria) this;
        }

        public Criteria andCompanyIn(List<String> values) {
            addCriterion("company in", values, "company");
            return (Criteria) this;
        }

        public Criteria andCompanyNotIn(List<String> values) {
            addCriterion("company not in", values, "company");
            return (Criteria) this;
        }

        public Criteria andCompanyBetween(String value1, String value2) {
            addCriterion("company between", value1, value2, "company");
            return (Criteria) this;
        }

        public Criteria andCompanyNotBetween(String value1, String value2) {
            addCriterion("company not between", value1, value2, "company");
            return (Criteria) this;
        }

        public Criteria andOwnerIsNull() {
            addCriterion("owner is null");
            return (Criteria) this;
        }

        public Criteria andOwnerIsNotNull() {
            addCriterion("owner is not null");
            return (Criteria) this;
        }

        public Criteria andOwnerEqualTo(String value) {
            addCriterion("owner =", value, "owner");
            return (Criteria) this;
        }

        public Criteria andOwnerNotEqualTo(String value) {
            addCriterion("owner <>", value, "owner");
            return (Criteria) this;
        }

        public Criteria andOwnerGreaterThan(String value) {
            addCriterion("owner >", value, "owner");
            return (Criteria) this;
        }

        public Criteria andOwnerGreaterThanOrEqualTo(String value) {
            addCriterion("owner >=", value, "owner");
            return (Criteria) this;
        }

        public Criteria andOwnerLessThan(String value) {
            addCriterion("owner <", value, "owner");
            return (Criteria) this;
        }

        public Criteria andOwnerLessThanOrEqualTo(String value) {
            addCriterion("owner <=", value, "owner");
            return (Criteria) this;
        }

        public Criteria andOwnerLike(String value) {
            addCriterion("owner like", value, "owner");
            return (Criteria) this;
        }

        public Criteria andOwnerNotLike(String value) {
            addCriterion("owner not like", value, "owner");
            return (Criteria) this;
        }

        public Criteria andOwnerIn(List<String> values) {
            addCriterion("owner in", values, "owner");
            return (Criteria) this;
        }

        public Criteria andOwnerNotIn(List<String> values) {
            addCriterion("owner not in", values, "owner");
            return (Criteria) this;
        }

        public Criteria andOwnerBetween(String value1, String value2) {
            addCriterion("owner between", value1, value2, "owner");
            return (Criteria) this;
        }

        public Criteria andOwnerNotBetween(String value1, String value2) {
            addCriterion("owner not between", value1, value2, "owner");
            return (Criteria) this;
        }

        public Criteria andSonOwnerIsNull() {
            addCriterion("son_owner is null");
            return (Criteria) this;
        }

        public Criteria andSonOwnerIsNotNull() {
            addCriterion("son_owner is not null");
            return (Criteria) this;
        }

        public Criteria andSonOwnerEqualTo(String value) {
            addCriterion("son_owner =", value, "sonOwner");
            return (Criteria) this;
        }

        public Criteria andSonOwnerNotEqualTo(String value) {
            addCriterion("son_owner <>", value, "sonOwner");
            return (Criteria) this;
        }

        public Criteria andSonOwnerGreaterThan(String value) {
            addCriterion("son_owner >", value, "sonOwner");
            return (Criteria) this;
        }

        public Criteria andSonOwnerGreaterThanOrEqualTo(String value) {
            addCriterion("son_owner >=", value, "sonOwner");
            return (Criteria) this;
        }

        public Criteria andSonOwnerLessThan(String value) {
            addCriterion("son_owner <", value, "sonOwner");
            return (Criteria) this;
        }

        public Criteria andSonOwnerLessThanOrEqualTo(String value) {
            addCriterion("son_owner <=", value, "sonOwner");
            return (Criteria) this;
        }

        public Criteria andSonOwnerLike(String value) {
            addCriterion("son_owner like", value, "sonOwner");
            return (Criteria) this;
        }

        public Criteria andSonOwnerNotLike(String value) {
            addCriterion("son_owner not like", value, "sonOwner");
            return (Criteria) this;
        }

        public Criteria andSonOwnerIn(List<String> values) {
            addCriterion("son_owner in", values, "sonOwner");
            return (Criteria) this;
        }

        public Criteria andSonOwnerNotIn(List<String> values) {
            addCriterion("son_owner not in", values, "sonOwner");
            return (Criteria) this;
        }

        public Criteria andSonOwnerBetween(String value1, String value2) {
            addCriterion("son_owner between", value1, value2, "sonOwner");
            return (Criteria) this;
        }

        public Criteria andSonOwnerNotBetween(String value1, String value2) {
            addCriterion("son_owner not between", value1, value2, "sonOwner");
            return (Criteria) this;
        }

        public Criteria andContractStatusIsNull() {
            addCriterion("contract_status is null");
            return (Criteria) this;
        }

        public Criteria andContractStatusIsNotNull() {
            addCriterion("contract_status is not null");
            return (Criteria) this;
        }

        public Criteria andContractStatusEqualTo(String value) {
            addCriterion("contract_status =", value, "contractStatus");
            return (Criteria) this;
        }

        public Criteria andContractStatusNotEqualTo(String value) {
            addCriterion("contract_status <>", value, "contractStatus");
            return (Criteria) this;
        }

        public Criteria andContractStatusGreaterThan(String value) {
            addCriterion("contract_status >", value, "contractStatus");
            return (Criteria) this;
        }

        public Criteria andContractStatusGreaterThanOrEqualTo(String value) {
            addCriterion("contract_status >=", value, "contractStatus");
            return (Criteria) this;
        }

        public Criteria andContractStatusLessThan(String value) {
            addCriterion("contract_status <", value, "contractStatus");
            return (Criteria) this;
        }

        public Criteria andContractStatusLessThanOrEqualTo(String value) {
            addCriterion("contract_status <=", value, "contractStatus");
            return (Criteria) this;
        }

        public Criteria andContractStatusLike(String value) {
            addCriterion("contract_status like", value, "contractStatus");
            return (Criteria) this;
        }

        public Criteria andContractStatusNotLike(String value) {
            addCriterion("contract_status not like", value, "contractStatus");
            return (Criteria) this;
        }

        public Criteria andContractStatusIn(List<String> values) {
            addCriterion("contract_status in", values, "contractStatus");
            return (Criteria) this;
        }

        public Criteria andContractStatusNotIn(List<String> values) {
            addCriterion("contract_status not in", values, "contractStatus");
            return (Criteria) this;
        }

        public Criteria andContractStatusBetween(String value1, String value2) {
            addCriterion("contract_status between", value1, value2, "contractStatus");
            return (Criteria) this;
        }

        public Criteria andContractStatusNotBetween(String value1, String value2) {
            addCriterion("contract_status not between", value1, value2, "contractStatus");
            return (Criteria) this;
        }

        public Criteria andContractNumberIsNull() {
            addCriterion("contract_number is null");
            return (Criteria) this;
        }

        public Criteria andContractNumberIsNotNull() {
            addCriterion("contract_number is not null");
            return (Criteria) this;
        }

        public Criteria andContractNumberEqualTo(String value) {
            addCriterion("contract_number =", value, "contractNumber");
            return (Criteria) this;
        }

        public Criteria andContractNumberNotEqualTo(String value) {
            addCriterion("contract_number <>", value, "contractNumber");
            return (Criteria) this;
        }

        public Criteria andContractNumberGreaterThan(String value) {
            addCriterion("contract_number >", value, "contractNumber");
            return (Criteria) this;
        }

        public Criteria andContractNumberGreaterThanOrEqualTo(String value) {
            addCriterion("contract_number >=", value, "contractNumber");
            return (Criteria) this;
        }

        public Criteria andContractNumberLessThan(String value) {
            addCriterion("contract_number <", value, "contractNumber");
            return (Criteria) this;
        }

        public Criteria andContractNumberLessThanOrEqualTo(String value) {
            addCriterion("contract_number <=", value, "contractNumber");
            return (Criteria) this;
        }

        public Criteria andContractNumberLike(String value) {
            addCriterion("contract_number like", value, "contractNumber");
            return (Criteria) this;
        }

        public Criteria andContractNumberNotLike(String value) {
            addCriterion("contract_number not like", value, "contractNumber");
            return (Criteria) this;
        }

        public Criteria andContractNumberIn(List<String> values) {
            addCriterion("contract_number in", values, "contractNumber");
            return (Criteria) this;
        }

        public Criteria andContractNumberNotIn(List<String> values) {
            addCriterion("contract_number not in", values, "contractNumber");
            return (Criteria) this;
        }

        public Criteria andContractNumberBetween(String value1, String value2) {
            addCriterion("contract_number between", value1, value2, "contractNumber");
            return (Criteria) this;
        }

        public Criteria andContractNumberNotBetween(String value1, String value2) {
            addCriterion("contract_number not between", value1, value2, "contractNumber");
            return (Criteria) this;
        }

        public Criteria andContractTypeIsNull() {
            addCriterion("contract_type is null");
            return (Criteria) this;
        }

        public Criteria andContractTypeIsNotNull() {
            addCriterion("contract_type is not null");
            return (Criteria) this;
        }

        public Criteria andContractTypeEqualTo(String value) {
            addCriterion("contract_type =", value, "contractType");
            return (Criteria) this;
        }

        public Criteria andContractTypeNotEqualTo(String value) {
            addCriterion("contract_type <>", value, "contractType");
            return (Criteria) this;
        }

        public Criteria andContractTypeGreaterThan(String value) {
            addCriterion("contract_type >", value, "contractType");
            return (Criteria) this;
        }

        public Criteria andContractTypeGreaterThanOrEqualTo(String value) {
            addCriterion("contract_type >=", value, "contractType");
            return (Criteria) this;
        }

        public Criteria andContractTypeLessThan(String value) {
            addCriterion("contract_type <", value, "contractType");
            return (Criteria) this;
        }

        public Criteria andContractTypeLessThanOrEqualTo(String value) {
            addCriterion("contract_type <=", value, "contractType");
            return (Criteria) this;
        }

        public Criteria andContractTypeLike(String value) {
            addCriterion("contract_type like", value, "contractType");
            return (Criteria) this;
        }

        public Criteria andContractTypeNotLike(String value) {
            addCriterion("contract_type not like", value, "contractType");
            return (Criteria) this;
        }

        public Criteria andContractTypeIn(List<String> values) {
            addCriterion("contract_type in", values, "contractType");
            return (Criteria) this;
        }

        public Criteria andContractTypeNotIn(List<String> values) {
            addCriterion("contract_type not in", values, "contractType");
            return (Criteria) this;
        }

        public Criteria andContractTypeBetween(String value1, String value2) {
            addCriterion("contract_type between", value1, value2, "contractType");
            return (Criteria) this;
        }

        public Criteria andContractTypeNotBetween(String value1, String value2) {
            addCriterion("contract_type not between", value1, value2, "contractType");
            return (Criteria) this;
        }

        public Criteria andMembershipTypeIsNull() {
            addCriterion("membership_type is null");
            return (Criteria) this;
        }

        public Criteria andMembershipTypeIsNotNull() {
            addCriterion("membership_type is not null");
            return (Criteria) this;
        }

        public Criteria andMembershipTypeEqualTo(String value) {
            addCriterion("membership_type =", value, "membershipType");
            return (Criteria) this;
        }

        public Criteria andMembershipTypeNotEqualTo(String value) {
            addCriterion("membership_type <>", value, "membershipType");
            return (Criteria) this;
        }

        public Criteria andMembershipTypeGreaterThan(String value) {
            addCriterion("membership_type >", value, "membershipType");
            return (Criteria) this;
        }

        public Criteria andMembershipTypeGreaterThanOrEqualTo(String value) {
            addCriterion("membership_type >=", value, "membershipType");
            return (Criteria) this;
        }

        public Criteria andMembershipTypeLessThan(String value) {
            addCriterion("membership_type <", value, "membershipType");
            return (Criteria) this;
        }

        public Criteria andMembershipTypeLessThanOrEqualTo(String value) {
            addCriterion("membership_type <=", value, "membershipType");
            return (Criteria) this;
        }

        public Criteria andMembershipTypeLike(String value) {
            addCriterion("membership_type like", value, "membershipType");
            return (Criteria) this;
        }

        public Criteria andMembershipTypeNotLike(String value) {
            addCriterion("membership_type not like", value, "membershipType");
            return (Criteria) this;
        }

        public Criteria andMembershipTypeIn(List<String> values) {
            addCriterion("membership_type in", values, "membershipType");
            return (Criteria) this;
        }

        public Criteria andMembershipTypeNotIn(List<String> values) {
            addCriterion("membership_type not in", values, "membershipType");
            return (Criteria) this;
        }

        public Criteria andMembershipTypeBetween(String value1, String value2) {
            addCriterion("membership_type between", value1, value2, "membershipType");
            return (Criteria) this;
        }

        public Criteria andMembershipTypeNotBetween(String value1, String value2) {
            addCriterion("membership_type not between", value1, value2, "membershipType");
            return (Criteria) this;
        }

        public Criteria andCustomerNameIsNull() {
            addCriterion("customer_name is null");
            return (Criteria) this;
        }

        public Criteria andCustomerNameIsNotNull() {
            addCriterion("customer_name is not null");
            return (Criteria) this;
        }

        public Criteria andCustomerNameEqualTo(String value) {
            addCriterion("customer_name =", value, "customerName");
            return (Criteria) this;
        }

        public Criteria andCustomerNameNotEqualTo(String value) {
            addCriterion("customer_name <>", value, "customerName");
            return (Criteria) this;
        }

        public Criteria andCustomerNameGreaterThan(String value) {
            addCriterion("customer_name >", value, "customerName");
            return (Criteria) this;
        }

        public Criteria andCustomerNameGreaterThanOrEqualTo(String value) {
            addCriterion("customer_name >=", value, "customerName");
            return (Criteria) this;
        }

        public Criteria andCustomerNameLessThan(String value) {
            addCriterion("customer_name <", value, "customerName");
            return (Criteria) this;
        }

        public Criteria andCustomerNameLessThanOrEqualTo(String value) {
            addCriterion("customer_name <=", value, "customerName");
            return (Criteria) this;
        }

        public Criteria andCustomerNameLike(String value) {
            addCriterion("customer_name like", value, "customerName");
            return (Criteria) this;
        }

        public Criteria andCustomerNameNotLike(String value) {
            addCriterion("customer_name not like", value, "customerName");
            return (Criteria) this;
        }

        public Criteria andCustomerNameIn(List<String> values) {
            addCriterion("customer_name in", values, "customerName");
            return (Criteria) this;
        }

        public Criteria andCustomerNameNotIn(List<String> values) {
            addCriterion("customer_name not in", values, "customerName");
            return (Criteria) this;
        }

        public Criteria andCustomerNameBetween(String value1, String value2) {
            addCriterion("customer_name between", value1, value2, "customerName");
            return (Criteria) this;
        }

        public Criteria andCustomerNameNotBetween(String value1, String value2) {
            addCriterion("customer_name not between", value1, value2, "customerName");
            return (Criteria) this;
        }

        public Criteria andMasterMemberContractIsNull() {
            addCriterion("master_member_contract is null");
            return (Criteria) this;
        }

        public Criteria andMasterMemberContractIsNotNull() {
            addCriterion("master_member_contract is not null");
            return (Criteria) this;
        }

        public Criteria andMasterMemberContractEqualTo(String value) {
            addCriterion("master_member_contract =", value, "masterMemberContract");
            return (Criteria) this;
        }

        public Criteria andMasterMemberContractNotEqualTo(String value) {
            addCriterion("master_member_contract <>", value, "masterMemberContract");
            return (Criteria) this;
        }

        public Criteria andMasterMemberContractGreaterThan(String value) {
            addCriterion("master_member_contract >", value, "masterMemberContract");
            return (Criteria) this;
        }

        public Criteria andMasterMemberContractGreaterThanOrEqualTo(String value) {
            addCriterion("master_member_contract >=", value, "masterMemberContract");
            return (Criteria) this;
        }

        public Criteria andMasterMemberContractLessThan(String value) {
            addCriterion("master_member_contract <", value, "masterMemberContract");
            return (Criteria) this;
        }

        public Criteria andMasterMemberContractLessThanOrEqualTo(String value) {
            addCriterion("master_member_contract <=", value, "masterMemberContract");
            return (Criteria) this;
        }

        public Criteria andMasterMemberContractLike(String value) {
            addCriterion("master_member_contract like", value, "masterMemberContract");
            return (Criteria) this;
        }

        public Criteria andMasterMemberContractNotLike(String value) {
            addCriterion("master_member_contract not like", value, "masterMemberContract");
            return (Criteria) this;
        }

        public Criteria andMasterMemberContractIn(List<String> values) {
            addCriterion("master_member_contract in", values, "masterMemberContract");
            return (Criteria) this;
        }

        public Criteria andMasterMemberContractNotIn(List<String> values) {
            addCriterion("master_member_contract not in", values, "masterMemberContract");
            return (Criteria) this;
        }

        public Criteria andMasterMemberContractBetween(String value1, String value2) {
            addCriterion("master_member_contract between", value1, value2, "masterMemberContract");
            return (Criteria) this;
        }

        public Criteria andMasterMemberContractNotBetween(String value1, String value2) {
            addCriterion("master_member_contract not between", value1, value2, "masterMemberContract");
            return (Criteria) this;
        }

        public Criteria andContractStartDateIsNull() {
            addCriterion("contract_start_date is null");
            return (Criteria) this;
        }

        public Criteria andContractStartDateIsNotNull() {
            addCriterion("contract_start_date is not null");
            return (Criteria) this;
        }

        public Criteria andContractStartDateEqualTo(String value) {
            addCriterion("contract_start_date =", value, "contractStartDate");
            return (Criteria) this;
        }

        public Criteria andContractStartDateNotEqualTo(String value) {
            addCriterion("contract_start_date <>", value, "contractStartDate");
            return (Criteria) this;
        }

        public Criteria andContractStartDateGreaterThan(String value) {
            addCriterion("contract_start_date >", value, "contractStartDate");
            return (Criteria) this;
        }

        public Criteria andContractStartDateGreaterThanOrEqualTo(String value) {
            addCriterion("contract_start_date >=", value, "contractStartDate");
            return (Criteria) this;
        }

        public Criteria andContractStartDateLessThan(String value) {
            addCriterion("contract_start_date <", value, "contractStartDate");
            return (Criteria) this;
        }

        public Criteria andContractStartDateLessThanOrEqualTo(String value) {
            addCriterion("contract_start_date <=", value, "contractStartDate");
            return (Criteria) this;
        }

        public Criteria andContractStartDateLike(String value) {
            addCriterion("contract_start_date like", value, "contractStartDate");
            return (Criteria) this;
        }

        public Criteria andContractStartDateNotLike(String value) {
            addCriterion("contract_start_date not like", value, "contractStartDate");
            return (Criteria) this;
        }

        public Criteria andContractStartDateIn(List<String> values) {
            addCriterion("contract_start_date in", values, "contractStartDate");
            return (Criteria) this;
        }

        public Criteria andContractStartDateNotIn(List<String> values) {
            addCriterion("contract_start_date not in", values, "contractStartDate");
            return (Criteria) this;
        }

        public Criteria andContractStartDateBetween(String value1, String value2) {
            addCriterion("contract_start_date between", value1, value2, "contractStartDate");
            return (Criteria) this;
        }

        public Criteria andContractStartDateNotBetween(String value1, String value2) {
            addCriterion("contract_start_date not between", value1, value2, "contractStartDate");
            return (Criteria) this;
        }

        public Criteria andContractEndDateIsNull() {
            addCriterion("contract_end_date is null");
            return (Criteria) this;
        }

        public Criteria andContractEndDateIsNotNull() {
            addCriterion("contract_end_date is not null");
            return (Criteria) this;
        }

        public Criteria andContractEndDateEqualTo(String value) {
            addCriterion("contract_end_date =", value, "contractEndDate");
            return (Criteria) this;
        }

        public Criteria andContractEndDateNotEqualTo(String value) {
            addCriterion("contract_end_date <>", value, "contractEndDate");
            return (Criteria) this;
        }

        public Criteria andContractEndDateGreaterThan(String value) {
            addCriterion("contract_end_date >", value, "contractEndDate");
            return (Criteria) this;
        }

        public Criteria andContractEndDateGreaterThanOrEqualTo(String value) {
            addCriterion("contract_end_date >=", value, "contractEndDate");
            return (Criteria) this;
        }

        public Criteria andContractEndDateLessThan(String value) {
            addCriterion("contract_end_date <", value, "contractEndDate");
            return (Criteria) this;
        }

        public Criteria andContractEndDateLessThanOrEqualTo(String value) {
            addCriterion("contract_end_date <=", value, "contractEndDate");
            return (Criteria) this;
        }

        public Criteria andContractEndDateLike(String value) {
            addCriterion("contract_end_date like", value, "contractEndDate");
            return (Criteria) this;
        }

        public Criteria andContractEndDateNotLike(String value) {
            addCriterion("contract_end_date not like", value, "contractEndDate");
            return (Criteria) this;
        }

        public Criteria andContractEndDateIn(List<String> values) {
            addCriterion("contract_end_date in", values, "contractEndDate");
            return (Criteria) this;
        }

        public Criteria andContractEndDateNotIn(List<String> values) {
            addCriterion("contract_end_date not in", values, "contractEndDate");
            return (Criteria) this;
        }

        public Criteria andContractEndDateBetween(String value1, String value2) {
            addCriterion("contract_end_date between", value1, value2, "contractEndDate");
            return (Criteria) this;
        }

        public Criteria andContractEndDateNotBetween(String value1, String value2) {
            addCriterion("contract_end_date not between", value1, value2, "contractEndDate");
            return (Criteria) this;
        }

        public Criteria andContractServiceTimeIsNull() {
            addCriterion("contract_service_time is null");
            return (Criteria) this;
        }

        public Criteria andContractServiceTimeIsNotNull() {
            addCriterion("contract_service_time is not null");
            return (Criteria) this;
        }

        public Criteria andContractServiceTimeEqualTo(String value) {
            addCriterion("contract_service_time =", value, "contractServiceTime");
            return (Criteria) this;
        }

        public Criteria andContractServiceTimeNotEqualTo(String value) {
            addCriterion("contract_service_time <>", value, "contractServiceTime");
            return (Criteria) this;
        }

        public Criteria andContractServiceTimeGreaterThan(String value) {
            addCriterion("contract_service_time >", value, "contractServiceTime");
            return (Criteria) this;
        }

        public Criteria andContractServiceTimeGreaterThanOrEqualTo(String value) {
            addCriterion("contract_service_time >=", value, "contractServiceTime");
            return (Criteria) this;
        }

        public Criteria andContractServiceTimeLessThan(String value) {
            addCriterion("contract_service_time <", value, "contractServiceTime");
            return (Criteria) this;
        }

        public Criteria andContractServiceTimeLessThanOrEqualTo(String value) {
            addCriterion("contract_service_time <=", value, "contractServiceTime");
            return (Criteria) this;
        }

        public Criteria andContractServiceTimeLike(String value) {
            addCriterion("contract_service_time like", value, "contractServiceTime");
            return (Criteria) this;
        }

        public Criteria andContractServiceTimeNotLike(String value) {
            addCriterion("contract_service_time not like", value, "contractServiceTime");
            return (Criteria) this;
        }

        public Criteria andContractServiceTimeIn(List<String> values) {
            addCriterion("contract_service_time in", values, "contractServiceTime");
            return (Criteria) this;
        }

        public Criteria andContractServiceTimeNotIn(List<String> values) {
            addCriterion("contract_service_time not in", values, "contractServiceTime");
            return (Criteria) this;
        }

        public Criteria andContractServiceTimeBetween(String value1, String value2) {
            addCriterion("contract_service_time between", value1, value2, "contractServiceTime");
            return (Criteria) this;
        }

        public Criteria andContractServiceTimeNotBetween(String value1, String value2) {
            addCriterion("contract_service_time not between", value1, value2, "contractServiceTime");
            return (Criteria) this;
        }

        public Criteria andPaperContractNumberIsNull() {
            addCriterion("paper_contract_number is null");
            return (Criteria) this;
        }

        public Criteria andPaperContractNumberIsNotNull() {
            addCriterion("paper_contract_number is not null");
            return (Criteria) this;
        }

        public Criteria andPaperContractNumberEqualTo(String value) {
            addCriterion("paper_contract_number =", value, "paperContractNumber");
            return (Criteria) this;
        }

        public Criteria andPaperContractNumberNotEqualTo(String value) {
            addCriterion("paper_contract_number <>", value, "paperContractNumber");
            return (Criteria) this;
        }

        public Criteria andPaperContractNumberGreaterThan(String value) {
            addCriterion("paper_contract_number >", value, "paperContractNumber");
            return (Criteria) this;
        }

        public Criteria andPaperContractNumberGreaterThanOrEqualTo(String value) {
            addCriterion("paper_contract_number >=", value, "paperContractNumber");
            return (Criteria) this;
        }

        public Criteria andPaperContractNumberLessThan(String value) {
            addCriterion("paper_contract_number <", value, "paperContractNumber");
            return (Criteria) this;
        }

        public Criteria andPaperContractNumberLessThanOrEqualTo(String value) {
            addCriterion("paper_contract_number <=", value, "paperContractNumber");
            return (Criteria) this;
        }

        public Criteria andPaperContractNumberLike(String value) {
            addCriterion("paper_contract_number like", value, "paperContractNumber");
            return (Criteria) this;
        }

        public Criteria andPaperContractNumberNotLike(String value) {
            addCriterion("paper_contract_number not like", value, "paperContractNumber");
            return (Criteria) this;
        }

        public Criteria andPaperContractNumberIn(List<String> values) {
            addCriterion("paper_contract_number in", values, "paperContractNumber");
            return (Criteria) this;
        }

        public Criteria andPaperContractNumberNotIn(List<String> values) {
            addCriterion("paper_contract_number not in", values, "paperContractNumber");
            return (Criteria) this;
        }

        public Criteria andPaperContractNumberBetween(String value1, String value2) {
            addCriterion("paper_contract_number between", value1, value2, "paperContractNumber");
            return (Criteria) this;
        }

        public Criteria andPaperContractNumberNotBetween(String value1, String value2) {
            addCriterion("paper_contract_number not between", value1, value2, "paperContractNumber");
            return (Criteria) this;
        }

        public Criteria andDescriptionIsNull() {
            addCriterion("description is null");
            return (Criteria) this;
        }

        public Criteria andDescriptionIsNotNull() {
            addCriterion("description is not null");
            return (Criteria) this;
        }

        public Criteria andDescriptionEqualTo(String value) {
            addCriterion("description =", value, "description");
            return (Criteria) this;
        }

        public Criteria andDescriptionNotEqualTo(String value) {
            addCriterion("description <>", value, "description");
            return (Criteria) this;
        }

        public Criteria andDescriptionGreaterThan(String value) {
            addCriterion("description >", value, "description");
            return (Criteria) this;
        }

        public Criteria andDescriptionGreaterThanOrEqualTo(String value) {
            addCriterion("description >=", value, "description");
            return (Criteria) this;
        }

        public Criteria andDescriptionLessThan(String value) {
            addCriterion("description <", value, "description");
            return (Criteria) this;
        }

        public Criteria andDescriptionLessThanOrEqualTo(String value) {
            addCriterion("description <=", value, "description");
            return (Criteria) this;
        }

        public Criteria andDescriptionLike(String value) {
            addCriterion("description like", value, "description");
            return (Criteria) this;
        }

        public Criteria andDescriptionNotLike(String value) {
            addCriterion("description not like", value, "description");
            return (Criteria) this;
        }

        public Criteria andDescriptionIn(List<String> values) {
            addCriterion("description in", values, "description");
            return (Criteria) this;
        }

        public Criteria andDescriptionNotIn(List<String> values) {
            addCriterion("description not in", values, "description");
            return (Criteria) this;
        }

        public Criteria andDescriptionBetween(String value1, String value2) {
            addCriterion("description between", value1, value2, "description");
            return (Criteria) this;
        }

        public Criteria andDescriptionNotBetween(String value1, String value2) {
            addCriterion("description not between", value1, value2, "description");
            return (Criteria) this;
        }

        public Criteria andLockStatusIsNull() {
            addCriterion("lock_status is null");
            return (Criteria) this;
        }

        public Criteria andLockStatusIsNotNull() {
            addCriterion("lock_status is not null");
            return (Criteria) this;
        }

        public Criteria andLockStatusEqualTo(String value) {
            addCriterion("lock_status =", value, "lockStatus");
            return (Criteria) this;
        }

        public Criteria andLockStatusNotEqualTo(String value) {
            addCriterion("lock_status <>", value, "lockStatus");
            return (Criteria) this;
        }

        public Criteria andLockStatusGreaterThan(String value) {
            addCriterion("lock_status >", value, "lockStatus");
            return (Criteria) this;
        }

        public Criteria andLockStatusGreaterThanOrEqualTo(String value) {
            addCriterion("lock_status >=", value, "lockStatus");
            return (Criteria) this;
        }

        public Criteria andLockStatusLessThan(String value) {
            addCriterion("lock_status <", value, "lockStatus");
            return (Criteria) this;
        }

        public Criteria andLockStatusLessThanOrEqualTo(String value) {
            addCriterion("lock_status <=", value, "lockStatus");
            return (Criteria) this;
        }

        public Criteria andLockStatusLike(String value) {
            addCriterion("lock_status like", value, "lockStatus");
            return (Criteria) this;
        }

        public Criteria andLockStatusNotLike(String value) {
            addCriterion("lock_status not like", value, "lockStatus");
            return (Criteria) this;
        }

        public Criteria andLockStatusIn(List<String> values) {
            addCriterion("lock_status in", values, "lockStatus");
            return (Criteria) this;
        }

        public Criteria andLockStatusNotIn(List<String> values) {
            addCriterion("lock_status not in", values, "lockStatus");
            return (Criteria) this;
        }

        public Criteria andLockStatusBetween(String value1, String value2) {
            addCriterion("lock_status between", value1, value2, "lockStatus");
            return (Criteria) this;
        }

        public Criteria andLockStatusNotBetween(String value1, String value2) {
            addCriterion("lock_status not between", value1, value2, "lockStatus");
            return (Criteria) this;
        }

        public Criteria andPaymentMethodIsNull() {
            addCriterion("payment_method is null");
            return (Criteria) this;
        }

        public Criteria andPaymentMethodIsNotNull() {
            addCriterion("payment_method is not null");
            return (Criteria) this;
        }

        public Criteria andPaymentMethodEqualTo(String value) {
            addCriterion("payment_method =", value, "paymentMethod");
            return (Criteria) this;
        }

        public Criteria andPaymentMethodNotEqualTo(String value) {
            addCriterion("payment_method <>", value, "paymentMethod");
            return (Criteria) this;
        }

        public Criteria andPaymentMethodGreaterThan(String value) {
            addCriterion("payment_method >", value, "paymentMethod");
            return (Criteria) this;
        }

        public Criteria andPaymentMethodGreaterThanOrEqualTo(String value) {
            addCriterion("payment_method >=", value, "paymentMethod");
            return (Criteria) this;
        }

        public Criteria andPaymentMethodLessThan(String value) {
            addCriterion("payment_method <", value, "paymentMethod");
            return (Criteria) this;
        }

        public Criteria andPaymentMethodLessThanOrEqualTo(String value) {
            addCriterion("payment_method <=", value, "paymentMethod");
            return (Criteria) this;
        }

        public Criteria andPaymentMethodLike(String value) {
            addCriterion("payment_method like", value, "paymentMethod");
            return (Criteria) this;
        }

        public Criteria andPaymentMethodNotLike(String value) {
            addCriterion("payment_method not like", value, "paymentMethod");
            return (Criteria) this;
        }

        public Criteria andPaymentMethodIn(List<String> values) {
            addCriterion("payment_method in", values, "paymentMethod");
            return (Criteria) this;
        }

        public Criteria andPaymentMethodNotIn(List<String> values) {
            addCriterion("payment_method not in", values, "paymentMethod");
            return (Criteria) this;
        }

        public Criteria andPaymentMethodBetween(String value1, String value2) {
            addCriterion("payment_method between", value1, value2, "paymentMethod");
            return (Criteria) this;
        }

        public Criteria andPaymentMethodNotBetween(String value1, String value2) {
            addCriterion("payment_method not between", value1, value2, "paymentMethod");
            return (Criteria) this;
        }

        public Criteria andWhetherHangIsNull() {
            addCriterion("whether_hang is null");
            return (Criteria) this;
        }

        public Criteria andWhetherHangIsNotNull() {
            addCriterion("whether_hang is not null");
            return (Criteria) this;
        }

        public Criteria andWhetherHangEqualTo(String value) {
            addCriterion("whether_hang =", value, "whetherHang");
            return (Criteria) this;
        }

        public Criteria andWhetherHangNotEqualTo(String value) {
            addCriterion("whether_hang <>", value, "whetherHang");
            return (Criteria) this;
        }

        public Criteria andWhetherHangGreaterThan(String value) {
            addCriterion("whether_hang >", value, "whetherHang");
            return (Criteria) this;
        }

        public Criteria andWhetherHangGreaterThanOrEqualTo(String value) {
            addCriterion("whether_hang >=", value, "whetherHang");
            return (Criteria) this;
        }

        public Criteria andWhetherHangLessThan(String value) {
            addCriterion("whether_hang <", value, "whetherHang");
            return (Criteria) this;
        }

        public Criteria andWhetherHangLessThanOrEqualTo(String value) {
            addCriterion("whether_hang <=", value, "whetherHang");
            return (Criteria) this;
        }

        public Criteria andWhetherHangLike(String value) {
            addCriterion("whether_hang like", value, "whetherHang");
            return (Criteria) this;
        }

        public Criteria andWhetherHangNotLike(String value) {
            addCriterion("whether_hang not like", value, "whetherHang");
            return (Criteria) this;
        }

        public Criteria andWhetherHangIn(List<String> values) {
            addCriterion("whether_hang in", values, "whetherHang");
            return (Criteria) this;
        }

        public Criteria andWhetherHangNotIn(List<String> values) {
            addCriterion("whether_hang not in", values, "whetherHang");
            return (Criteria) this;
        }

        public Criteria andWhetherHangBetween(String value1, String value2) {
            addCriterion("whether_hang between", value1, value2, "whetherHang");
            return (Criteria) this;
        }

        public Criteria andWhetherHangNotBetween(String value1, String value2) {
            addCriterion("whether_hang not between", value1, value2, "whetherHang");
            return (Criteria) this;
        }

        public Criteria andUnitPriceOfMembershipCardIsNull() {
            addCriterion("unit_price_of_membership_card is null");
            return (Criteria) this;
        }

        public Criteria andUnitPriceOfMembershipCardIsNotNull() {
            addCriterion("unit_price_of_membership_card is not null");
            return (Criteria) this;
        }

        public Criteria andUnitPriceOfMembershipCardEqualTo(String value) {
            addCriterion("unit_price_of_membership_card =", value, "unitPriceOfMembershipCard");
            return (Criteria) this;
        }

        public Criteria andUnitPriceOfMembershipCardNotEqualTo(String value) {
            addCriterion("unit_price_of_membership_card <>", value, "unitPriceOfMembershipCard");
            return (Criteria) this;
        }

        public Criteria andUnitPriceOfMembershipCardGreaterThan(String value) {
            addCriterion("unit_price_of_membership_card >", value, "unitPriceOfMembershipCard");
            return (Criteria) this;
        }

        public Criteria andUnitPriceOfMembershipCardGreaterThanOrEqualTo(String value) {
            addCriterion("unit_price_of_membership_card >=", value, "unitPriceOfMembershipCard");
            return (Criteria) this;
        }

        public Criteria andUnitPriceOfMembershipCardLessThan(String value) {
            addCriterion("unit_price_of_membership_card <", value, "unitPriceOfMembershipCard");
            return (Criteria) this;
        }

        public Criteria andUnitPriceOfMembershipCardLessThanOrEqualTo(String value) {
            addCriterion("unit_price_of_membership_card <=", value, "unitPriceOfMembershipCard");
            return (Criteria) this;
        }

        public Criteria andUnitPriceOfMembershipCardLike(String value) {
            addCriterion("unit_price_of_membership_card like", value, "unitPriceOfMembershipCard");
            return (Criteria) this;
        }

        public Criteria andUnitPriceOfMembershipCardNotLike(String value) {
            addCriterion("unit_price_of_membership_card not like", value, "unitPriceOfMembershipCard");
            return (Criteria) this;
        }

        public Criteria andUnitPriceOfMembershipCardIn(List<String> values) {
            addCriterion("unit_price_of_membership_card in", values, "unitPriceOfMembershipCard");
            return (Criteria) this;
        }

        public Criteria andUnitPriceOfMembershipCardNotIn(List<String> values) {
            addCriterion("unit_price_of_membership_card not in", values, "unitPriceOfMembershipCard");
            return (Criteria) this;
        }

        public Criteria andUnitPriceOfMembershipCardBetween(String value1, String value2) {
            addCriterion("unit_price_of_membership_card between", value1, value2, "unitPriceOfMembershipCard");
            return (Criteria) this;
        }

        public Criteria andUnitPriceOfMembershipCardNotBetween(String value1, String value2) {
            addCriterion("unit_price_of_membership_card not between", value1, value2, "unitPriceOfMembershipCard");
            return (Criteria) this;
        }

        public Criteria andMemberDiscountAmountIsNull() {
            addCriterion("member_discount_amount is null");
            return (Criteria) this;
        }

        public Criteria andMemberDiscountAmountIsNotNull() {
            addCriterion("member_discount_amount is not null");
            return (Criteria) this;
        }

        public Criteria andMemberDiscountAmountEqualTo(String value) {
            addCriterion("member_discount_amount =", value, "memberDiscountAmount");
            return (Criteria) this;
        }

        public Criteria andMemberDiscountAmountNotEqualTo(String value) {
            addCriterion("member_discount_amount <>", value, "memberDiscountAmount");
            return (Criteria) this;
        }

        public Criteria andMemberDiscountAmountGreaterThan(String value) {
            addCriterion("member_discount_amount >", value, "memberDiscountAmount");
            return (Criteria) this;
        }

        public Criteria andMemberDiscountAmountGreaterThanOrEqualTo(String value) {
            addCriterion("member_discount_amount >=", value, "memberDiscountAmount");
            return (Criteria) this;
        }

        public Criteria andMemberDiscountAmountLessThan(String value) {
            addCriterion("member_discount_amount <", value, "memberDiscountAmount");
            return (Criteria) this;
        }

        public Criteria andMemberDiscountAmountLessThanOrEqualTo(String value) {
            addCriterion("member_discount_amount <=", value, "memberDiscountAmount");
            return (Criteria) this;
        }

        public Criteria andMemberDiscountAmountLike(String value) {
            addCriterion("member_discount_amount like", value, "memberDiscountAmount");
            return (Criteria) this;
        }

        public Criteria andMemberDiscountAmountNotLike(String value) {
            addCriterion("member_discount_amount not like", value, "memberDiscountAmount");
            return (Criteria) this;
        }

        public Criteria andMemberDiscountAmountIn(List<String> values) {
            addCriterion("member_discount_amount in", values, "memberDiscountAmount");
            return (Criteria) this;
        }

        public Criteria andMemberDiscountAmountNotIn(List<String> values) {
            addCriterion("member_discount_amount not in", values, "memberDiscountAmount");
            return (Criteria) this;
        }

        public Criteria andMemberDiscountAmountBetween(String value1, String value2) {
            addCriterion("member_discount_amount between", value1, value2, "memberDiscountAmount");
            return (Criteria) this;
        }

        public Criteria andMemberDiscountAmountNotBetween(String value1, String value2) {
            addCriterion("member_discount_amount not between", value1, value2, "memberDiscountAmount");
            return (Criteria) this;
        }

        public Criteria andMemberDiscountDescriptionIsNull() {
            addCriterion("member_discount_description is null");
            return (Criteria) this;
        }

        public Criteria andMemberDiscountDescriptionIsNotNull() {
            addCriterion("member_discount_description is not null");
            return (Criteria) this;
        }

        public Criteria andMemberDiscountDescriptionEqualTo(String value) {
            addCriterion("member_discount_description =", value, "memberDiscountDescription");
            return (Criteria) this;
        }

        public Criteria andMemberDiscountDescriptionNotEqualTo(String value) {
            addCriterion("member_discount_description <>", value, "memberDiscountDescription");
            return (Criteria) this;
        }

        public Criteria andMemberDiscountDescriptionGreaterThan(String value) {
            addCriterion("member_discount_description >", value, "memberDiscountDescription");
            return (Criteria) this;
        }

        public Criteria andMemberDiscountDescriptionGreaterThanOrEqualTo(String value) {
            addCriterion("member_discount_description >=", value, "memberDiscountDescription");
            return (Criteria) this;
        }

        public Criteria andMemberDiscountDescriptionLessThan(String value) {
            addCriterion("member_discount_description <", value, "memberDiscountDescription");
            return (Criteria) this;
        }

        public Criteria andMemberDiscountDescriptionLessThanOrEqualTo(String value) {
            addCriterion("member_discount_description <=", value, "memberDiscountDescription");
            return (Criteria) this;
        }

        public Criteria andMemberDiscountDescriptionLike(String value) {
            addCriterion("member_discount_description like", value, "memberDiscountDescription");
            return (Criteria) this;
        }

        public Criteria andMemberDiscountDescriptionNotLike(String value) {
            addCriterion("member_discount_description not like", value, "memberDiscountDescription");
            return (Criteria) this;
        }

        public Criteria andMemberDiscountDescriptionIn(List<String> values) {
            addCriterion("member_discount_description in", values, "memberDiscountDescription");
            return (Criteria) this;
        }

        public Criteria andMemberDiscountDescriptionNotIn(List<String> values) {
            addCriterion("member_discount_description not in", values, "memberDiscountDescription");
            return (Criteria) this;
        }

        public Criteria andMemberDiscountDescriptionBetween(String value1, String value2) {
            addCriterion("member_discount_description between", value1, value2, "memberDiscountDescription");
            return (Criteria) this;
        }

        public Criteria andMemberDiscountDescriptionNotBetween(String value1, String value2) {
            addCriterion("member_discount_description not between", value1, value2, "memberDiscountDescription");
            return (Criteria) this;
        }

        public Criteria andActualTransactionAmountOfMembersIsNull() {
            addCriterion("actual_transaction_amount_of_members is null");
            return (Criteria) this;
        }

        public Criteria andActualTransactionAmountOfMembersIsNotNull() {
            addCriterion("actual_transaction_amount_of_members is not null");
            return (Criteria) this;
        }

        public Criteria andActualTransactionAmountOfMembersEqualTo(String value) {
            addCriterion("actual_transaction_amount_of_members =", value, "actualTransactionAmountOfMembers");
            return (Criteria) this;
        }

        public Criteria andActualTransactionAmountOfMembersNotEqualTo(String value) {
            addCriterion("actual_transaction_amount_of_members <>", value, "actualTransactionAmountOfMembers");
            return (Criteria) this;
        }

        public Criteria andActualTransactionAmountOfMembersGreaterThan(String value) {
            addCriterion("actual_transaction_amount_of_members >", value, "actualTransactionAmountOfMembers");
            return (Criteria) this;
        }

        public Criteria andActualTransactionAmountOfMembersGreaterThanOrEqualTo(String value) {
            addCriterion("actual_transaction_amount_of_members >=", value, "actualTransactionAmountOfMembers");
            return (Criteria) this;
        }

        public Criteria andActualTransactionAmountOfMembersLessThan(String value) {
            addCriterion("actual_transaction_amount_of_members <", value, "actualTransactionAmountOfMembers");
            return (Criteria) this;
        }

        public Criteria andActualTransactionAmountOfMembersLessThanOrEqualTo(String value) {
            addCriterion("actual_transaction_amount_of_members <=", value, "actualTransactionAmountOfMembers");
            return (Criteria) this;
        }

        public Criteria andActualTransactionAmountOfMembersLike(String value) {
            addCriterion("actual_transaction_amount_of_members like", value, "actualTransactionAmountOfMembers");
            return (Criteria) this;
        }

        public Criteria andActualTransactionAmountOfMembersNotLike(String value) {
            addCriterion("actual_transaction_amount_of_members not like", value, "actualTransactionAmountOfMembers");
            return (Criteria) this;
        }

        public Criteria andActualTransactionAmountOfMembersIn(List<String> values) {
            addCriterion("actual_transaction_amount_of_members in", values, "actualTransactionAmountOfMembers");
            return (Criteria) this;
        }

        public Criteria andActualTransactionAmountOfMembersNotIn(List<String> values) {
            addCriterion("actual_transaction_amount_of_members not in", values, "actualTransactionAmountOfMembers");
            return (Criteria) this;
        }

        public Criteria andActualTransactionAmountOfMembersBetween(String value1, String value2) {
            addCriterion("actual_transaction_amount_of_members between", value1, value2, "actualTransactionAmountOfMembers");
            return (Criteria) this;
        }

        public Criteria andActualTransactionAmountOfMembersNotBetween(String value1, String value2) {
            addCriterion("actual_transaction_amount_of_members not between", value1, value2, "actualTransactionAmountOfMembers");
            return (Criteria) this;
        }

        public Criteria andMasterMembershipCardTypeIsNull() {
            addCriterion("master_membership_card_type is null");
            return (Criteria) this;
        }

        public Criteria andMasterMembershipCardTypeIsNotNull() {
            addCriterion("master_membership_card_type is not null");
            return (Criteria) this;
        }

        public Criteria andMasterMembershipCardTypeEqualTo(String value) {
            addCriterion("master_membership_card_type =", value, "masterMembershipCardType");
            return (Criteria) this;
        }

        public Criteria andMasterMembershipCardTypeNotEqualTo(String value) {
            addCriterion("master_membership_card_type <>", value, "masterMembershipCardType");
            return (Criteria) this;
        }

        public Criteria andMasterMembershipCardTypeGreaterThan(String value) {
            addCriterion("master_membership_card_type >", value, "masterMembershipCardType");
            return (Criteria) this;
        }

        public Criteria andMasterMembershipCardTypeGreaterThanOrEqualTo(String value) {
            addCriterion("master_membership_card_type >=", value, "masterMembershipCardType");
            return (Criteria) this;
        }

        public Criteria andMasterMembershipCardTypeLessThan(String value) {
            addCriterion("master_membership_card_type <", value, "masterMembershipCardType");
            return (Criteria) this;
        }

        public Criteria andMasterMembershipCardTypeLessThanOrEqualTo(String value) {
            addCriterion("master_membership_card_type <=", value, "masterMembershipCardType");
            return (Criteria) this;
        }

        public Criteria andMasterMembershipCardTypeLike(String value) {
            addCriterion("master_membership_card_type like", value, "masterMembershipCardType");
            return (Criteria) this;
        }

        public Criteria andMasterMembershipCardTypeNotLike(String value) {
            addCriterion("master_membership_card_type not like", value, "masterMembershipCardType");
            return (Criteria) this;
        }

        public Criteria andMasterMembershipCardTypeIn(List<String> values) {
            addCriterion("master_membership_card_type in", values, "masterMembershipCardType");
            return (Criteria) this;
        }

        public Criteria andMasterMembershipCardTypeNotIn(List<String> values) {
            addCriterion("master_membership_card_type not in", values, "masterMembershipCardType");
            return (Criteria) this;
        }

        public Criteria andMasterMembershipCardTypeBetween(String value1, String value2) {
            addCriterion("master_membership_card_type between", value1, value2, "masterMembershipCardType");
            return (Criteria) this;
        }

        public Criteria andMasterMembershipCardTypeNotBetween(String value1, String value2) {
            addCriterion("master_membership_card_type not between", value1, value2, "masterMembershipCardType");
            return (Criteria) this;
        }

        public Criteria andCooperativeDevelopmentOrNotIsNull() {
            addCriterion("cooperative_development_or_not is null");
            return (Criteria) this;
        }

        public Criteria andCooperativeDevelopmentOrNotIsNotNull() {
            addCriterion("cooperative_development_or_not is not null");
            return (Criteria) this;
        }

        public Criteria andCooperativeDevelopmentOrNotEqualTo(String value) {
            addCriterion("cooperative_development_or_not =", value, "cooperativeDevelopmentOrNot");
            return (Criteria) this;
        }

        public Criteria andCooperativeDevelopmentOrNotNotEqualTo(String value) {
            addCriterion("cooperative_development_or_not <>", value, "cooperativeDevelopmentOrNot");
            return (Criteria) this;
        }

        public Criteria andCooperativeDevelopmentOrNotGreaterThan(String value) {
            addCriterion("cooperative_development_or_not >", value, "cooperativeDevelopmentOrNot");
            return (Criteria) this;
        }

        public Criteria andCooperativeDevelopmentOrNotGreaterThanOrEqualTo(String value) {
            addCriterion("cooperative_development_or_not >=", value, "cooperativeDevelopmentOrNot");
            return (Criteria) this;
        }

        public Criteria andCooperativeDevelopmentOrNotLessThan(String value) {
            addCriterion("cooperative_development_or_not <", value, "cooperativeDevelopmentOrNot");
            return (Criteria) this;
        }

        public Criteria andCooperativeDevelopmentOrNotLessThanOrEqualTo(String value) {
            addCriterion("cooperative_development_or_not <=", value, "cooperativeDevelopmentOrNot");
            return (Criteria) this;
        }

        public Criteria andCooperativeDevelopmentOrNotLike(String value) {
            addCriterion("cooperative_development_or_not like", value, "cooperativeDevelopmentOrNot");
            return (Criteria) this;
        }

        public Criteria andCooperativeDevelopmentOrNotNotLike(String value) {
            addCriterion("cooperative_development_or_not not like", value, "cooperativeDevelopmentOrNot");
            return (Criteria) this;
        }

        public Criteria andCooperativeDevelopmentOrNotIn(List<String> values) {
            addCriterion("cooperative_development_or_not in", values, "cooperativeDevelopmentOrNot");
            return (Criteria) this;
        }

        public Criteria andCooperativeDevelopmentOrNotNotIn(List<String> values) {
            addCriterion("cooperative_development_or_not not in", values, "cooperativeDevelopmentOrNot");
            return (Criteria) this;
        }

        public Criteria andCooperativeDevelopmentOrNotBetween(String value1, String value2) {
            addCriterion("cooperative_development_or_not between", value1, value2, "cooperativeDevelopmentOrNot");
            return (Criteria) this;
        }

        public Criteria andCooperativeDevelopmentOrNotNotBetween(String value1, String value2) {
            addCriterion("cooperative_development_or_not not between", value1, value2, "cooperativeDevelopmentOrNot");
            return (Criteria) this;
        }

        public Criteria andCooperativeDeveloperIsNull() {
            addCriterion("cooperative_developer is null");
            return (Criteria) this;
        }

        public Criteria andCooperativeDeveloperIsNotNull() {
            addCriterion("cooperative_developer is not null");
            return (Criteria) this;
        }

        public Criteria andCooperativeDeveloperEqualTo(String value) {
            addCriterion("cooperative_developer =", value, "cooperativeDeveloper");
            return (Criteria) this;
        }

        public Criteria andCooperativeDeveloperNotEqualTo(String value) {
            addCriterion("cooperative_developer <>", value, "cooperativeDeveloper");
            return (Criteria) this;
        }

        public Criteria andCooperativeDeveloperGreaterThan(String value) {
            addCriterion("cooperative_developer >", value, "cooperativeDeveloper");
            return (Criteria) this;
        }

        public Criteria andCooperativeDeveloperGreaterThanOrEqualTo(String value) {
            addCriterion("cooperative_developer >=", value, "cooperativeDeveloper");
            return (Criteria) this;
        }

        public Criteria andCooperativeDeveloperLessThan(String value) {
            addCriterion("cooperative_developer <", value, "cooperativeDeveloper");
            return (Criteria) this;
        }

        public Criteria andCooperativeDeveloperLessThanOrEqualTo(String value) {
            addCriterion("cooperative_developer <=", value, "cooperativeDeveloper");
            return (Criteria) this;
        }

        public Criteria andCooperativeDeveloperLike(String value) {
            addCriterion("cooperative_developer like", value, "cooperativeDeveloper");
            return (Criteria) this;
        }

        public Criteria andCooperativeDeveloperNotLike(String value) {
            addCriterion("cooperative_developer not like", value, "cooperativeDeveloper");
            return (Criteria) this;
        }

        public Criteria andCooperativeDeveloperIn(List<String> values) {
            addCriterion("cooperative_developer in", values, "cooperativeDeveloper");
            return (Criteria) this;
        }

        public Criteria andCooperativeDeveloperNotIn(List<String> values) {
            addCriterion("cooperative_developer not in", values, "cooperativeDeveloper");
            return (Criteria) this;
        }

        public Criteria andCooperativeDeveloperBetween(String value1, String value2) {
            addCriterion("cooperative_developer between", value1, value2, "cooperativeDeveloper");
            return (Criteria) this;
        }

        public Criteria andCooperativeDeveloperNotBetween(String value1, String value2) {
            addCriterion("cooperative_developer not between", value1, value2, "cooperativeDeveloper");
            return (Criteria) this;
        }

        public Criteria andBindMobilePhoneNumIsNull() {
            addCriterion("bind_mobile_phone_num is null");
            return (Criteria) this;
        }

        public Criteria andBindMobilePhoneNumIsNotNull() {
            addCriterion("bind_mobile_phone_num is not null");
            return (Criteria) this;
        }

        public Criteria andBindMobilePhoneNumEqualTo(String value) {
            addCriterion("bind_mobile_phone_num =", value, "bindMobilePhoneNum");
            return (Criteria) this;
        }

        public Criteria andBindMobilePhoneNumNotEqualTo(String value) {
            addCriterion("bind_mobile_phone_num <>", value, "bindMobilePhoneNum");
            return (Criteria) this;
        }

        public Criteria andBindMobilePhoneNumGreaterThan(String value) {
            addCriterion("bind_mobile_phone_num >", value, "bindMobilePhoneNum");
            return (Criteria) this;
        }

        public Criteria andBindMobilePhoneNumGreaterThanOrEqualTo(String value) {
            addCriterion("bind_mobile_phone_num >=", value, "bindMobilePhoneNum");
            return (Criteria) this;
        }

        public Criteria andBindMobilePhoneNumLessThan(String value) {
            addCriterion("bind_mobile_phone_num <", value, "bindMobilePhoneNum");
            return (Criteria) this;
        }

        public Criteria andBindMobilePhoneNumLessThanOrEqualTo(String value) {
            addCriterion("bind_mobile_phone_num <=", value, "bindMobilePhoneNum");
            return (Criteria) this;
        }

        public Criteria andBindMobilePhoneNumLike(String value) {
            addCriterion("bind_mobile_phone_num like", value, "bindMobilePhoneNum");
            return (Criteria) this;
        }

        public Criteria andBindMobilePhoneNumNotLike(String value) {
            addCriterion("bind_mobile_phone_num not like", value, "bindMobilePhoneNum");
            return (Criteria) this;
        }

        public Criteria andBindMobilePhoneNumIn(List<String> values) {
            addCriterion("bind_mobile_phone_num in", values, "bindMobilePhoneNum");
            return (Criteria) this;
        }

        public Criteria andBindMobilePhoneNumNotIn(List<String> values) {
            addCriterion("bind_mobile_phone_num not in", values, "bindMobilePhoneNum");
            return (Criteria) this;
        }

        public Criteria andBindMobilePhoneNumBetween(String value1, String value2) {
            addCriterion("bind_mobile_phone_num between", value1, value2, "bindMobilePhoneNum");
            return (Criteria) this;
        }

        public Criteria andBindMobilePhoneNumNotBetween(String value1, String value2) {
            addCriterion("bind_mobile_phone_num not between", value1, value2, "bindMobilePhoneNum");
            return (Criteria) this;
        }

        public Criteria andContactPersonIsNull() {
            addCriterion("contact_person is null");
            return (Criteria) this;
        }

        public Criteria andContactPersonIsNotNull() {
            addCriterion("contact_person is not null");
            return (Criteria) this;
        }

        public Criteria andContactPersonEqualTo(String value) {
            addCriterion("contact_person =", value, "contactPerson");
            return (Criteria) this;
        }

        public Criteria andContactPersonNotEqualTo(String value) {
            addCriterion("contact_person <>", value, "contactPerson");
            return (Criteria) this;
        }

        public Criteria andContactPersonGreaterThan(String value) {
            addCriterion("contact_person >", value, "contactPerson");
            return (Criteria) this;
        }

        public Criteria andContactPersonGreaterThanOrEqualTo(String value) {
            addCriterion("contact_person >=", value, "contactPerson");
            return (Criteria) this;
        }

        public Criteria andContactPersonLessThan(String value) {
            addCriterion("contact_person <", value, "contactPerson");
            return (Criteria) this;
        }

        public Criteria andContactPersonLessThanOrEqualTo(String value) {
            addCriterion("contact_person <=", value, "contactPerson");
            return (Criteria) this;
        }

        public Criteria andContactPersonLike(String value) {
            addCriterion("contact_person like", value, "contactPerson");
            return (Criteria) this;
        }

        public Criteria andContactPersonNotLike(String value) {
            addCriterion("contact_person not like", value, "contactPerson");
            return (Criteria) this;
        }

        public Criteria andContactPersonIn(List<String> values) {
            addCriterion("contact_person in", values, "contactPerson");
            return (Criteria) this;
        }

        public Criteria andContactPersonNotIn(List<String> values) {
            addCriterion("contact_person not in", values, "contactPerson");
            return (Criteria) this;
        }

        public Criteria andContactPersonBetween(String value1, String value2) {
            addCriterion("contact_person between", value1, value2, "contactPerson");
            return (Criteria) this;
        }

        public Criteria andContactPersonNotBetween(String value1, String value2) {
            addCriterion("contact_person not between", value1, value2, "contactPerson");
            return (Criteria) this;
        }

        public Criteria andProductCodeIsNull() {
            addCriterion("product_code is null");
            return (Criteria) this;
        }

        public Criteria andProductCodeIsNotNull() {
            addCriterion("product_code is not null");
            return (Criteria) this;
        }

        public Criteria andProductCodeEqualTo(String value) {
            addCriterion("product_code =", value, "productCode");
            return (Criteria) this;
        }

        public Criteria andProductCodeNotEqualTo(String value) {
            addCriterion("product_code <>", value, "productCode");
            return (Criteria) this;
        }

        public Criteria andProductCodeGreaterThan(String value) {
            addCriterion("product_code >", value, "productCode");
            return (Criteria) this;
        }

        public Criteria andProductCodeGreaterThanOrEqualTo(String value) {
            addCriterion("product_code >=", value, "productCode");
            return (Criteria) this;
        }

        public Criteria andProductCodeLessThan(String value) {
            addCriterion("product_code <", value, "productCode");
            return (Criteria) this;
        }

        public Criteria andProductCodeLessThanOrEqualTo(String value) {
            addCriterion("product_code <=", value, "productCode");
            return (Criteria) this;
        }

        public Criteria andProductCodeLike(String value) {
            addCriterion("product_code like", value, "productCode");
            return (Criteria) this;
        }

        public Criteria andProductCodeNotLike(String value) {
            addCriterion("product_code not like", value, "productCode");
            return (Criteria) this;
        }

        public Criteria andProductCodeIn(List<String> values) {
            addCriterion("product_code in", values, "productCode");
            return (Criteria) this;
        }

        public Criteria andProductCodeNotIn(List<String> values) {
            addCriterion("product_code not in", values, "productCode");
            return (Criteria) this;
        }

        public Criteria andProductCodeBetween(String value1, String value2) {
            addCriterion("product_code between", value1, value2, "productCode");
            return (Criteria) this;
        }

        public Criteria andProductCodeNotBetween(String value1, String value2) {
            addCriterion("product_code not between", value1, value2, "productCode");
            return (Criteria) this;
        }

        public Criteria andArrivalMoneyDateIsNull() {
            addCriterion("arrival_money_date is null");
            return (Criteria) this;
        }

        public Criteria andArrivalMoneyDateIsNotNull() {
            addCriterion("arrival_money_date is not null");
            return (Criteria) this;
        }

        public Criteria andArrivalMoneyDateEqualTo(String value) {
            addCriterion("arrival_money_date =", value, "arrivalMoneyDate");
            return (Criteria) this;
        }

        public Criteria andArrivalMoneyDateNotEqualTo(String value) {
            addCriterion("arrival_money_date <>", value, "arrivalMoneyDate");
            return (Criteria) this;
        }

        public Criteria andArrivalMoneyDateGreaterThan(String value) {
            addCriterion("arrival_money_date >", value, "arrivalMoneyDate");
            return (Criteria) this;
        }

        public Criteria andArrivalMoneyDateGreaterThanOrEqualTo(String value) {
            addCriterion("arrival_money_date >=", value, "arrivalMoneyDate");
            return (Criteria) this;
        }

        public Criteria andArrivalMoneyDateLessThan(String value) {
            addCriterion("arrival_money_date <", value, "arrivalMoneyDate");
            return (Criteria) this;
        }

        public Criteria andArrivalMoneyDateLessThanOrEqualTo(String value) {
            addCriterion("arrival_money_date <=", value, "arrivalMoneyDate");
            return (Criteria) this;
        }

        public Criteria andArrivalMoneyDateLike(String value) {
            addCriterion("arrival_money_date like", value, "arrivalMoneyDate");
            return (Criteria) this;
        }

        public Criteria andArrivalMoneyDateNotLike(String value) {
            addCriterion("arrival_money_date not like", value, "arrivalMoneyDate");
            return (Criteria) this;
        }

        public Criteria andArrivalMoneyDateIn(List<String> values) {
            addCriterion("arrival_money_date in", values, "arrivalMoneyDate");
            return (Criteria) this;
        }

        public Criteria andArrivalMoneyDateNotIn(List<String> values) {
            addCriterion("arrival_money_date not in", values, "arrivalMoneyDate");
            return (Criteria) this;
        }

        public Criteria andArrivalMoneyDateBetween(String value1, String value2) {
            addCriterion("arrival_money_date between", value1, value2, "arrivalMoneyDate");
            return (Criteria) this;
        }

        public Criteria andArrivalMoneyDateNotBetween(String value1, String value2) {
            addCriterion("arrival_money_date not between", value1, value2, "arrivalMoneyDate");
            return (Criteria) this;
        }

        public Criteria andWhetherHasRefundIsNull() {
            addCriterion("whether_has_refund is null");
            return (Criteria) this;
        }

        public Criteria andWhetherHasRefundIsNotNull() {
            addCriterion("whether_has_refund is not null");
            return (Criteria) this;
        }

        public Criteria andWhetherHasRefundEqualTo(String value) {
            addCriterion("whether_has_refund =", value, "whetherHasRefund");
            return (Criteria) this;
        }

        public Criteria andWhetherHasRefundNotEqualTo(String value) {
            addCriterion("whether_has_refund <>", value, "whetherHasRefund");
            return (Criteria) this;
        }

        public Criteria andWhetherHasRefundGreaterThan(String value) {
            addCriterion("whether_has_refund >", value, "whetherHasRefund");
            return (Criteria) this;
        }

        public Criteria andWhetherHasRefundGreaterThanOrEqualTo(String value) {
            addCriterion("whether_has_refund >=", value, "whetherHasRefund");
            return (Criteria) this;
        }

        public Criteria andWhetherHasRefundLessThan(String value) {
            addCriterion("whether_has_refund <", value, "whetherHasRefund");
            return (Criteria) this;
        }

        public Criteria andWhetherHasRefundLessThanOrEqualTo(String value) {
            addCriterion("whether_has_refund <=", value, "whetherHasRefund");
            return (Criteria) this;
        }

        public Criteria andWhetherHasRefundLike(String value) {
            addCriterion("whether_has_refund like", value, "whetherHasRefund");
            return (Criteria) this;
        }

        public Criteria andWhetherHasRefundNotLike(String value) {
            addCriterion("whether_has_refund not like", value, "whetherHasRefund");
            return (Criteria) this;
        }

        public Criteria andWhetherHasRefundIn(List<String> values) {
            addCriterion("whether_has_refund in", values, "whetherHasRefund");
            return (Criteria) this;
        }

        public Criteria andWhetherHasRefundNotIn(List<String> values) {
            addCriterion("whether_has_refund not in", values, "whetherHasRefund");
            return (Criteria) this;
        }

        public Criteria andWhetherHasRefundBetween(String value1, String value2) {
            addCriterion("whether_has_refund between", value1, value2, "whetherHasRefund");
            return (Criteria) this;
        }

        public Criteria andWhetherHasRefundNotBetween(String value1, String value2) {
            addCriterion("whether_has_refund not between", value1, value2, "whetherHasRefund");
            return (Criteria) this;
        }

        public Criteria andCompanyNumberIsNull() {
            addCriterion("company_number is null");
            return (Criteria) this;
        }

        public Criteria andCompanyNumberIsNotNull() {
            addCriterion("company_number is not null");
            return (Criteria) this;
        }

        public Criteria andCompanyNumberEqualTo(String value) {
            addCriterion("company_number =", value, "companyNumber");
            return (Criteria) this;
        }

        public Criteria andCompanyNumberNotEqualTo(String value) {
            addCriterion("company_number <>", value, "companyNumber");
            return (Criteria) this;
        }

        public Criteria andCompanyNumberGreaterThan(String value) {
            addCriterion("company_number >", value, "companyNumber");
            return (Criteria) this;
        }

        public Criteria andCompanyNumberGreaterThanOrEqualTo(String value) {
            addCriterion("company_number >=", value, "companyNumber");
            return (Criteria) this;
        }

        public Criteria andCompanyNumberLessThan(String value) {
            addCriterion("company_number <", value, "companyNumber");
            return (Criteria) this;
        }

        public Criteria andCompanyNumberLessThanOrEqualTo(String value) {
            addCriterion("company_number <=", value, "companyNumber");
            return (Criteria) this;
        }

        public Criteria andCompanyNumberLike(String value) {
            addCriterion("company_number like", value, "companyNumber");
            return (Criteria) this;
        }

        public Criteria andCompanyNumberNotLike(String value) {
            addCriterion("company_number not like", value, "companyNumber");
            return (Criteria) this;
        }

        public Criteria andCompanyNumberIn(List<String> values) {
            addCriterion("company_number in", values, "companyNumber");
            return (Criteria) this;
        }

        public Criteria andCompanyNumberNotIn(List<String> values) {
            addCriterion("company_number not in", values, "companyNumber");
            return (Criteria) this;
        }

        public Criteria andCompanyNumberBetween(String value1, String value2) {
            addCriterion("company_number between", value1, value2, "companyNumber");
            return (Criteria) this;
        }

        public Criteria andCompanyNumberNotBetween(String value1, String value2) {
            addCriterion("company_number not between", value1, value2, "companyNumber");
            return (Criteria) this;
        }

        public Criteria andWhetherToDeleteOrNotIsNull() {
            addCriterion("whether_to_delete_or_not is null");
            return (Criteria) this;
        }

        public Criteria andWhetherToDeleteOrNotIsNotNull() {
            addCriterion("whether_to_delete_or_not is not null");
            return (Criteria) this;
        }

        public Criteria andWhetherToDeleteOrNotEqualTo(String value) {
            addCriterion("whether_to_delete_or_not =", value, "whetherToDeleteOrNot");
            return (Criteria) this;
        }

        public Criteria andWhetherToDeleteOrNotNotEqualTo(String value) {
            addCriterion("whether_to_delete_or_not <>", value, "whetherToDeleteOrNot");
            return (Criteria) this;
        }

        public Criteria andWhetherToDeleteOrNotGreaterThan(String value) {
            addCriterion("whether_to_delete_or_not >", value, "whetherToDeleteOrNot");
            return (Criteria) this;
        }

        public Criteria andWhetherToDeleteOrNotGreaterThanOrEqualTo(String value) {
            addCriterion("whether_to_delete_or_not >=", value, "whetherToDeleteOrNot");
            return (Criteria) this;
        }

        public Criteria andWhetherToDeleteOrNotLessThan(String value) {
            addCriterion("whether_to_delete_or_not <", value, "whetherToDeleteOrNot");
            return (Criteria) this;
        }

        public Criteria andWhetherToDeleteOrNotLessThanOrEqualTo(String value) {
            addCriterion("whether_to_delete_or_not <=", value, "whetherToDeleteOrNot");
            return (Criteria) this;
        }

        public Criteria andWhetherToDeleteOrNotLike(String value) {
            addCriterion("whether_to_delete_or_not like", value, "whetherToDeleteOrNot");
            return (Criteria) this;
        }

        public Criteria andWhetherToDeleteOrNotNotLike(String value) {
            addCriterion("whether_to_delete_or_not not like", value, "whetherToDeleteOrNot");
            return (Criteria) this;
        }

        public Criteria andWhetherToDeleteOrNotIn(List<String> values) {
            addCriterion("whether_to_delete_or_not in", values, "whetherToDeleteOrNot");
            return (Criteria) this;
        }

        public Criteria andWhetherToDeleteOrNotNotIn(List<String> values) {
            addCriterion("whether_to_delete_or_not not in", values, "whetherToDeleteOrNot");
            return (Criteria) this;
        }

        public Criteria andWhetherToDeleteOrNotBetween(String value1, String value2) {
            addCriterion("whether_to_delete_or_not between", value1, value2, "whetherToDeleteOrNot");
            return (Criteria) this;
        }

        public Criteria andWhetherToDeleteOrNotNotBetween(String value1, String value2) {
            addCriterion("whether_to_delete_or_not not between", value1, value2, "whetherToDeleteOrNot");
            return (Criteria) this;
        }

        public Criteria andAttachmentIsNull() {
            addCriterion("attachment is null");
            return (Criteria) this;
        }

        public Criteria andAttachmentIsNotNull() {
            addCriterion("attachment is not null");
            return (Criteria) this;
        }

        public Criteria andAttachmentEqualTo(String value) {
            addCriterion("attachment =", value, "attachment");
            return (Criteria) this;
        }

        public Criteria andAttachmentNotEqualTo(String value) {
            addCriterion("attachment <>", value, "attachment");
            return (Criteria) this;
        }

        public Criteria andAttachmentGreaterThan(String value) {
            addCriterion("attachment >", value, "attachment");
            return (Criteria) this;
        }

        public Criteria andAttachmentGreaterThanOrEqualTo(String value) {
            addCriterion("attachment >=", value, "attachment");
            return (Criteria) this;
        }

        public Criteria andAttachmentLessThan(String value) {
            addCriterion("attachment <", value, "attachment");
            return (Criteria) this;
        }

        public Criteria andAttachmentLessThanOrEqualTo(String value) {
            addCriterion("attachment <=", value, "attachment");
            return (Criteria) this;
        }

        public Criteria andAttachmentLike(String value) {
            addCriterion("attachment like", value, "attachment");
            return (Criteria) this;
        }

        public Criteria andAttachmentNotLike(String value) {
            addCriterion("attachment not like", value, "attachment");
            return (Criteria) this;
        }

        public Criteria andAttachmentIn(List<String> values) {
            addCriterion("attachment in", values, "attachment");
            return (Criteria) this;
        }

        public Criteria andAttachmentNotIn(List<String> values) {
            addCriterion("attachment not in", values, "attachment");
            return (Criteria) this;
        }

        public Criteria andAttachmentBetween(String value1, String value2) {
            addCriterion("attachment between", value1, value2, "attachment");
            return (Criteria) this;
        }

        public Criteria andAttachmentNotBetween(String value1, String value2) {
            addCriterion("attachment not between", value1, value2, "attachment");
            return (Criteria) this;
        }

        public Criteria andWhetherTheInspectionIsNull() {
            addCriterion("whether_the_inspection is null");
            return (Criteria) this;
        }

        public Criteria andWhetherTheInspectionIsNotNull() {
            addCriterion("whether_the_inspection is not null");
            return (Criteria) this;
        }

        public Criteria andWhetherTheInspectionEqualTo(String value) {
            addCriterion("whether_the_inspection =", value, "whetherTheInspection");
            return (Criteria) this;
        }

        public Criteria andWhetherTheInspectionNotEqualTo(String value) {
            addCriterion("whether_the_inspection <>", value, "whetherTheInspection");
            return (Criteria) this;
        }

        public Criteria andWhetherTheInspectionGreaterThan(String value) {
            addCriterion("whether_the_inspection >", value, "whetherTheInspection");
            return (Criteria) this;
        }

        public Criteria andWhetherTheInspectionGreaterThanOrEqualTo(String value) {
            addCriterion("whether_the_inspection >=", value, "whetherTheInspection");
            return (Criteria) this;
        }

        public Criteria andWhetherTheInspectionLessThan(String value) {
            addCriterion("whether_the_inspection <", value, "whetherTheInspection");
            return (Criteria) this;
        }

        public Criteria andWhetherTheInspectionLessThanOrEqualTo(String value) {
            addCriterion("whether_the_inspection <=", value, "whetherTheInspection");
            return (Criteria) this;
        }

        public Criteria andWhetherTheInspectionLike(String value) {
            addCriterion("whether_the_inspection like", value, "whetherTheInspection");
            return (Criteria) this;
        }

        public Criteria andWhetherTheInspectionNotLike(String value) {
            addCriterion("whether_the_inspection not like", value, "whetherTheInspection");
            return (Criteria) this;
        }

        public Criteria andWhetherTheInspectionIn(List<String> values) {
            addCriterion("whether_the_inspection in", values, "whetherTheInspection");
            return (Criteria) this;
        }

        public Criteria andWhetherTheInspectionNotIn(List<String> values) {
            addCriterion("whether_the_inspection not in", values, "whetherTheInspection");
            return (Criteria) this;
        }

        public Criteria andWhetherTheInspectionBetween(String value1, String value2) {
            addCriterion("whether_the_inspection between", value1, value2, "whetherTheInspection");
            return (Criteria) this;
        }

        public Criteria andWhetherTheInspectionNotBetween(String value1, String value2) {
            addCriterion("whether_the_inspection not between", value1, value2, "whetherTheInspection");
            return (Criteria) this;
        }

        public Criteria andOriginalCustomerIdIsNull() {
            addCriterion("original_customer_id is null");
            return (Criteria) this;
        }

        public Criteria andOriginalCustomerIdIsNotNull() {
            addCriterion("original_customer_id is not null");
            return (Criteria) this;
        }

        public Criteria andOriginalCustomerIdEqualTo(String value) {
            addCriterion("original_customer_id =", value, "originalCustomerId");
            return (Criteria) this;
        }

        public Criteria andOriginalCustomerIdNotEqualTo(String value) {
            addCriterion("original_customer_id <>", value, "originalCustomerId");
            return (Criteria) this;
        }

        public Criteria andOriginalCustomerIdGreaterThan(String value) {
            addCriterion("original_customer_id >", value, "originalCustomerId");
            return (Criteria) this;
        }

        public Criteria andOriginalCustomerIdGreaterThanOrEqualTo(String value) {
            addCriterion("original_customer_id >=", value, "originalCustomerId");
            return (Criteria) this;
        }

        public Criteria andOriginalCustomerIdLessThan(String value) {
            addCriterion("original_customer_id <", value, "originalCustomerId");
            return (Criteria) this;
        }

        public Criteria andOriginalCustomerIdLessThanOrEqualTo(String value) {
            addCriterion("original_customer_id <=", value, "originalCustomerId");
            return (Criteria) this;
        }

        public Criteria andOriginalCustomerIdLike(String value) {
            addCriterion("original_customer_id like", value, "originalCustomerId");
            return (Criteria) this;
        }

        public Criteria andOriginalCustomerIdNotLike(String value) {
            addCriterion("original_customer_id not like", value, "originalCustomerId");
            return (Criteria) this;
        }

        public Criteria andOriginalCustomerIdIn(List<String> values) {
            addCriterion("original_customer_id in", values, "originalCustomerId");
            return (Criteria) this;
        }

        public Criteria andOriginalCustomerIdNotIn(List<String> values) {
            addCriterion("original_customer_id not in", values, "originalCustomerId");
            return (Criteria) this;
        }

        public Criteria andOriginalCustomerIdBetween(String value1, String value2) {
            addCriterion("original_customer_id between", value1, value2, "originalCustomerId");
            return (Criteria) this;
        }

        public Criteria andOriginalCustomerIdNotBetween(String value1, String value2) {
            addCriterion("original_customer_id not between", value1, value2, "originalCustomerId");
            return (Criteria) this;
        }

        public Criteria andClueClassificationIsNull() {
            addCriterion("clue_classification is null");
            return (Criteria) this;
        }

        public Criteria andClueClassificationIsNotNull() {
            addCriterion("clue_classification is not null");
            return (Criteria) this;
        }

        public Criteria andClueClassificationEqualTo(String value) {
            addCriterion("clue_classification =", value, "clueClassification");
            return (Criteria) this;
        }

        public Criteria andClueClassificationNotEqualTo(String value) {
            addCriterion("clue_classification <>", value, "clueClassification");
            return (Criteria) this;
        }

        public Criteria andClueClassificationGreaterThan(String value) {
            addCriterion("clue_classification >", value, "clueClassification");
            return (Criteria) this;
        }

        public Criteria andClueClassificationGreaterThanOrEqualTo(String value) {
            addCriterion("clue_classification >=", value, "clueClassification");
            return (Criteria) this;
        }

        public Criteria andClueClassificationLessThan(String value) {
            addCriterion("clue_classification <", value, "clueClassification");
            return (Criteria) this;
        }

        public Criteria andClueClassificationLessThanOrEqualTo(String value) {
            addCriterion("clue_classification <=", value, "clueClassification");
            return (Criteria) this;
        }

        public Criteria andClueClassificationLike(String value) {
            addCriterion("clue_classification like", value, "clueClassification");
            return (Criteria) this;
        }

        public Criteria andClueClassificationNotLike(String value) {
            addCriterion("clue_classification not like", value, "clueClassification");
            return (Criteria) this;
        }

        public Criteria andClueClassificationIn(List<String> values) {
            addCriterion("clue_classification in", values, "clueClassification");
            return (Criteria) this;
        }

        public Criteria andClueClassificationNotIn(List<String> values) {
            addCriterion("clue_classification not in", values, "clueClassification");
            return (Criteria) this;
        }

        public Criteria andClueClassificationBetween(String value1, String value2) {
            addCriterion("clue_classification between", value1, value2, "clueClassification");
            return (Criteria) this;
        }

        public Criteria andClueClassificationNotBetween(String value1, String value2) {
            addCriterion("clue_classification not between", value1, value2, "clueClassification");
            return (Criteria) this;
        }

        public Criteria andContractRenewalIsNull() {
            addCriterion("contract_renewal is null");
            return (Criteria) this;
        }

        public Criteria andContractRenewalIsNotNull() {
            addCriterion("contract_renewal is not null");
            return (Criteria) this;
        }

        public Criteria andContractRenewalEqualTo(String value) {
            addCriterion("contract_renewal =", value, "contractRenewal");
            return (Criteria) this;
        }

        public Criteria andContractRenewalNotEqualTo(String value) {
            addCriterion("contract_renewal <>", value, "contractRenewal");
            return (Criteria) this;
        }

        public Criteria andContractRenewalGreaterThan(String value) {
            addCriterion("contract_renewal >", value, "contractRenewal");
            return (Criteria) this;
        }

        public Criteria andContractRenewalGreaterThanOrEqualTo(String value) {
            addCriterion("contract_renewal >=", value, "contractRenewal");
            return (Criteria) this;
        }

        public Criteria andContractRenewalLessThan(String value) {
            addCriterion("contract_renewal <", value, "contractRenewal");
            return (Criteria) this;
        }

        public Criteria andContractRenewalLessThanOrEqualTo(String value) {
            addCriterion("contract_renewal <=", value, "contractRenewal");
            return (Criteria) this;
        }

        public Criteria andContractRenewalLike(String value) {
            addCriterion("contract_renewal like", value, "contractRenewal");
            return (Criteria) this;
        }

        public Criteria andContractRenewalNotLike(String value) {
            addCriterion("contract_renewal not like", value, "contractRenewal");
            return (Criteria) this;
        }

        public Criteria andContractRenewalIn(List<String> values) {
            addCriterion("contract_renewal in", values, "contractRenewal");
            return (Criteria) this;
        }

        public Criteria andContractRenewalNotIn(List<String> values) {
            addCriterion("contract_renewal not in", values, "contractRenewal");
            return (Criteria) this;
        }

        public Criteria andContractRenewalBetween(String value1, String value2) {
            addCriterion("contract_renewal between", value1, value2, "contractRenewal");
            return (Criteria) this;
        }

        public Criteria andContractRenewalNotBetween(String value1, String value2) {
            addCriterion("contract_renewal not between", value1, value2, "contractRenewal");
            return (Criteria) this;
        }

        public Criteria andReasonsForAdvanceOrDelayIsNull() {
            addCriterion("reasons_for_advance_or_delay is null");
            return (Criteria) this;
        }

        public Criteria andReasonsForAdvanceOrDelayIsNotNull() {
            addCriterion("reasons_for_advance_or_delay is not null");
            return (Criteria) this;
        }

        public Criteria andReasonsForAdvanceOrDelayEqualTo(String value) {
            addCriterion("reasons_for_advance_or_delay =", value, "reasonsForAdvanceOrDelay");
            return (Criteria) this;
        }

        public Criteria andReasonsForAdvanceOrDelayNotEqualTo(String value) {
            addCriterion("reasons_for_advance_or_delay <>", value, "reasonsForAdvanceOrDelay");
            return (Criteria) this;
        }

        public Criteria andReasonsForAdvanceOrDelayGreaterThan(String value) {
            addCriterion("reasons_for_advance_or_delay >", value, "reasonsForAdvanceOrDelay");
            return (Criteria) this;
        }

        public Criteria andReasonsForAdvanceOrDelayGreaterThanOrEqualTo(String value) {
            addCriterion("reasons_for_advance_or_delay >=", value, "reasonsForAdvanceOrDelay");
            return (Criteria) this;
        }

        public Criteria andReasonsForAdvanceOrDelayLessThan(String value) {
            addCriterion("reasons_for_advance_or_delay <", value, "reasonsForAdvanceOrDelay");
            return (Criteria) this;
        }

        public Criteria andReasonsForAdvanceOrDelayLessThanOrEqualTo(String value) {
            addCriterion("reasons_for_advance_or_delay <=", value, "reasonsForAdvanceOrDelay");
            return (Criteria) this;
        }

        public Criteria andReasonsForAdvanceOrDelayLike(String value) {
            addCriterion("reasons_for_advance_or_delay like", value, "reasonsForAdvanceOrDelay");
            return (Criteria) this;
        }

        public Criteria andReasonsForAdvanceOrDelayNotLike(String value) {
            addCriterion("reasons_for_advance_or_delay not like", value, "reasonsForAdvanceOrDelay");
            return (Criteria) this;
        }

        public Criteria andReasonsForAdvanceOrDelayIn(List<String> values) {
            addCriterion("reasons_for_advance_or_delay in", values, "reasonsForAdvanceOrDelay");
            return (Criteria) this;
        }

        public Criteria andReasonsForAdvanceOrDelayNotIn(List<String> values) {
            addCriterion("reasons_for_advance_or_delay not in", values, "reasonsForAdvanceOrDelay");
            return (Criteria) this;
        }

        public Criteria andReasonsForAdvanceOrDelayBetween(String value1, String value2) {
            addCriterion("reasons_for_advance_or_delay between", value1, value2, "reasonsForAdvanceOrDelay");
            return (Criteria) this;
        }

        public Criteria andReasonsForAdvanceOrDelayNotBetween(String value1, String value2) {
            addCriterion("reasons_for_advance_or_delay not between", value1, value2, "reasonsForAdvanceOrDelay");
            return (Criteria) this;
        }

        public Criteria andMembershipCardTypeIsNull() {
            addCriterion("membership_card_type is null");
            return (Criteria) this;
        }

        public Criteria andMembershipCardTypeIsNotNull() {
            addCriterion("membership_card_type is not null");
            return (Criteria) this;
        }

        public Criteria andMembershipCardTypeEqualTo(String value) {
            addCriterion("membership_card_type =", value, "membershipCardType");
            return (Criteria) this;
        }

        public Criteria andMembershipCardTypeNotEqualTo(String value) {
            addCriterion("membership_card_type <>", value, "membershipCardType");
            return (Criteria) this;
        }

        public Criteria andMembershipCardTypeGreaterThan(String value) {
            addCriterion("membership_card_type >", value, "membershipCardType");
            return (Criteria) this;
        }

        public Criteria andMembershipCardTypeGreaterThanOrEqualTo(String value) {
            addCriterion("membership_card_type >=", value, "membershipCardType");
            return (Criteria) this;
        }

        public Criteria andMembershipCardTypeLessThan(String value) {
            addCriterion("membership_card_type <", value, "membershipCardType");
            return (Criteria) this;
        }

        public Criteria andMembershipCardTypeLessThanOrEqualTo(String value) {
            addCriterion("membership_card_type <=", value, "membershipCardType");
            return (Criteria) this;
        }

        public Criteria andMembershipCardTypeLike(String value) {
            addCriterion("membership_card_type like", value, "membershipCardType");
            return (Criteria) this;
        }

        public Criteria andMembershipCardTypeNotLike(String value) {
            addCriterion("membership_card_type not like", value, "membershipCardType");
            return (Criteria) this;
        }

        public Criteria andMembershipCardTypeIn(List<String> values) {
            addCriterion("membership_card_type in", values, "membershipCardType");
            return (Criteria) this;
        }

        public Criteria andMembershipCardTypeNotIn(List<String> values) {
            addCriterion("membership_card_type not in", values, "membershipCardType");
            return (Criteria) this;
        }

        public Criteria andMembershipCardTypeBetween(String value1, String value2) {
            addCriterion("membership_card_type between", value1, value2, "membershipCardType");
            return (Criteria) this;
        }

        public Criteria andMembershipCardTypeNotBetween(String value1, String value2) {
            addCriterion("membership_card_type not between", value1, value2, "membershipCardType");
            return (Criteria) this;
        }

        public Criteria andMailboxIsNull() {
            addCriterion("mailbox is null");
            return (Criteria) this;
        }

        public Criteria andMailboxIsNotNull() {
            addCriterion("mailbox is not null");
            return (Criteria) this;
        }

        public Criteria andMailboxEqualTo(String value) {
            addCriterion("mailbox =", value, "mailbox");
            return (Criteria) this;
        }

        public Criteria andMailboxNotEqualTo(String value) {
            addCriterion("mailbox <>", value, "mailbox");
            return (Criteria) this;
        }

        public Criteria andMailboxGreaterThan(String value) {
            addCriterion("mailbox >", value, "mailbox");
            return (Criteria) this;
        }

        public Criteria andMailboxGreaterThanOrEqualTo(String value) {
            addCriterion("mailbox >=", value, "mailbox");
            return (Criteria) this;
        }

        public Criteria andMailboxLessThan(String value) {
            addCriterion("mailbox <", value, "mailbox");
            return (Criteria) this;
        }

        public Criteria andMailboxLessThanOrEqualTo(String value) {
            addCriterion("mailbox <=", value, "mailbox");
            return (Criteria) this;
        }

        public Criteria andMailboxLike(String value) {
            addCriterion("mailbox like", value, "mailbox");
            return (Criteria) this;
        }

        public Criteria andMailboxNotLike(String value) {
            addCriterion("mailbox not like", value, "mailbox");
            return (Criteria) this;
        }

        public Criteria andMailboxIn(List<String> values) {
            addCriterion("mailbox in", values, "mailbox");
            return (Criteria) this;
        }

        public Criteria andMailboxNotIn(List<String> values) {
            addCriterion("mailbox not in", values, "mailbox");
            return (Criteria) this;
        }

        public Criteria andMailboxBetween(String value1, String value2) {
            addCriterion("mailbox between", value1, value2, "mailbox");
            return (Criteria) this;
        }

        public Criteria andMailboxNotBetween(String value1, String value2) {
            addCriterion("mailbox not between", value1, value2, "mailbox");
            return (Criteria) this;
        }

        public Criteria andTotalContractAmountIsNull() {
            addCriterion("total_contract_amount is null");
            return (Criteria) this;
        }

        public Criteria andTotalContractAmountIsNotNull() {
            addCriterion("total_contract_amount is not null");
            return (Criteria) this;
        }

        public Criteria andTotalContractAmountEqualTo(String value) {
            addCriterion("total_contract_amount =", value, "totalContractAmount");
            return (Criteria) this;
        }

        public Criteria andTotalContractAmountNotEqualTo(String value) {
            addCriterion("total_contract_amount <>", value, "totalContractAmount");
            return (Criteria) this;
        }

        public Criteria andTotalContractAmountGreaterThan(String value) {
            addCriterion("total_contract_amount >", value, "totalContractAmount");
            return (Criteria) this;
        }

        public Criteria andTotalContractAmountGreaterThanOrEqualTo(String value) {
            addCriterion("total_contract_amount >=", value, "totalContractAmount");
            return (Criteria) this;
        }

        public Criteria andTotalContractAmountLessThan(String value) {
            addCriterion("total_contract_amount <", value, "totalContractAmount");
            return (Criteria) this;
        }

        public Criteria andTotalContractAmountLessThanOrEqualTo(String value) {
            addCriterion("total_contract_amount <=", value, "totalContractAmount");
            return (Criteria) this;
        }

        public Criteria andTotalContractAmountLike(String value) {
            addCriterion("total_contract_amount like", value, "totalContractAmount");
            return (Criteria) this;
        }

        public Criteria andTotalContractAmountNotLike(String value) {
            addCriterion("total_contract_amount not like", value, "totalContractAmount");
            return (Criteria) this;
        }

        public Criteria andTotalContractAmountIn(List<String> values) {
            addCriterion("total_contract_amount in", values, "totalContractAmount");
            return (Criteria) this;
        }

        public Criteria andTotalContractAmountNotIn(List<String> values) {
            addCriterion("total_contract_amount not in", values, "totalContractAmount");
            return (Criteria) this;
        }

        public Criteria andTotalContractAmountBetween(String value1, String value2) {
            addCriterion("total_contract_amount between", value1, value2, "totalContractAmount");
            return (Criteria) this;
        }

        public Criteria andTotalContractAmountNotBetween(String value1, String value2) {
            addCriterion("total_contract_amount not between", value1, value2, "totalContractAmount");
            return (Criteria) this;
        }

        public Criteria andTotalAmountOfContractDiscountIsNull() {
            addCriterion("total_amount_of_contract_discount is null");
            return (Criteria) this;
        }

        public Criteria andTotalAmountOfContractDiscountIsNotNull() {
            addCriterion("total_amount_of_contract_discount is not null");
            return (Criteria) this;
        }

        public Criteria andTotalAmountOfContractDiscountEqualTo(String value) {
            addCriterion("total_amount_of_contract_discount =", value, "totalAmountOfContractDiscount");
            return (Criteria) this;
        }

        public Criteria andTotalAmountOfContractDiscountNotEqualTo(String value) {
            addCriterion("total_amount_of_contract_discount <>", value, "totalAmountOfContractDiscount");
            return (Criteria) this;
        }

        public Criteria andTotalAmountOfContractDiscountGreaterThan(String value) {
            addCriterion("total_amount_of_contract_discount >", value, "totalAmountOfContractDiscount");
            return (Criteria) this;
        }

        public Criteria andTotalAmountOfContractDiscountGreaterThanOrEqualTo(String value) {
            addCriterion("total_amount_of_contract_discount >=", value, "totalAmountOfContractDiscount");
            return (Criteria) this;
        }

        public Criteria andTotalAmountOfContractDiscountLessThan(String value) {
            addCriterion("total_amount_of_contract_discount <", value, "totalAmountOfContractDiscount");
            return (Criteria) this;
        }

        public Criteria andTotalAmountOfContractDiscountLessThanOrEqualTo(String value) {
            addCriterion("total_amount_of_contract_discount <=", value, "totalAmountOfContractDiscount");
            return (Criteria) this;
        }

        public Criteria andTotalAmountOfContractDiscountLike(String value) {
            addCriterion("total_amount_of_contract_discount like", value, "totalAmountOfContractDiscount");
            return (Criteria) this;
        }

        public Criteria andTotalAmountOfContractDiscountNotLike(String value) {
            addCriterion("total_amount_of_contract_discount not like", value, "totalAmountOfContractDiscount");
            return (Criteria) this;
        }

        public Criteria andTotalAmountOfContractDiscountIn(List<String> values) {
            addCriterion("total_amount_of_contract_discount in", values, "totalAmountOfContractDiscount");
            return (Criteria) this;
        }

        public Criteria andTotalAmountOfContractDiscountNotIn(List<String> values) {
            addCriterion("total_amount_of_contract_discount not in", values, "totalAmountOfContractDiscount");
            return (Criteria) this;
        }

        public Criteria andTotalAmountOfContractDiscountBetween(String value1, String value2) {
            addCriterion("total_amount_of_contract_discount between", value1, value2, "totalAmountOfContractDiscount");
            return (Criteria) this;
        }

        public Criteria andTotalAmountOfContractDiscountNotBetween(String value1, String value2) {
            addCriterion("total_amount_of_contract_discount not between", value1, value2, "totalAmountOfContractDiscount");
            return (Criteria) this;
        }

        public Criteria andActualTotalContractAmountIsNull() {
            addCriterion("actual_total_contract_amount is null");
            return (Criteria) this;
        }

        public Criteria andActualTotalContractAmountIsNotNull() {
            addCriterion("actual_total_contract_amount is not null");
            return (Criteria) this;
        }

        public Criteria andActualTotalContractAmountEqualTo(String value) {
            addCriterion("actual_total_contract_amount =", value, "actualTotalContractAmount");
            return (Criteria) this;
        }

        public Criteria andActualTotalContractAmountNotEqualTo(String value) {
            addCriterion("actual_total_contract_amount <>", value, "actualTotalContractAmount");
            return (Criteria) this;
        }

        public Criteria andActualTotalContractAmountGreaterThan(String value) {
            addCriterion("actual_total_contract_amount >", value, "actualTotalContractAmount");
            return (Criteria) this;
        }

        public Criteria andActualTotalContractAmountGreaterThanOrEqualTo(String value) {
            addCriterion("actual_total_contract_amount >=", value, "actualTotalContractAmount");
            return (Criteria) this;
        }

        public Criteria andActualTotalContractAmountLessThan(String value) {
            addCriterion("actual_total_contract_amount <", value, "actualTotalContractAmount");
            return (Criteria) this;
        }

        public Criteria andActualTotalContractAmountLessThanOrEqualTo(String value) {
            addCriterion("actual_total_contract_amount <=", value, "actualTotalContractAmount");
            return (Criteria) this;
        }

        public Criteria andActualTotalContractAmountLike(String value) {
            addCriterion("actual_total_contract_amount like", value, "actualTotalContractAmount");
            return (Criteria) this;
        }

        public Criteria andActualTotalContractAmountNotLike(String value) {
            addCriterion("actual_total_contract_amount not like", value, "actualTotalContractAmount");
            return (Criteria) this;
        }

        public Criteria andActualTotalContractAmountIn(List<String> values) {
            addCriterion("actual_total_contract_amount in", values, "actualTotalContractAmount");
            return (Criteria) this;
        }

        public Criteria andActualTotalContractAmountNotIn(List<String> values) {
            addCriterion("actual_total_contract_amount not in", values, "actualTotalContractAmount");
            return (Criteria) this;
        }

        public Criteria andActualTotalContractAmountBetween(String value1, String value2) {
            addCriterion("actual_total_contract_amount between", value1, value2, "actualTotalContractAmount");
            return (Criteria) this;
        }

        public Criteria andActualTotalContractAmountNotBetween(String value1, String value2) {
            addCriterion("actual_total_contract_amount not between", value1, value2, "actualTotalContractAmount");
            return (Criteria) this;
        }

        public Criteria andTotalPaybackAmountOfContractIsNull() {
            addCriterion("total_payback_amount_of_contract is null");
            return (Criteria) this;
        }

        public Criteria andTotalPaybackAmountOfContractIsNotNull() {
            addCriterion("total_payback_amount_of_contract is not null");
            return (Criteria) this;
        }

        public Criteria andTotalPaybackAmountOfContractEqualTo(String value) {
            addCriterion("total_payback_amount_of_contract =", value, "totalPaybackAmountOfContract");
            return (Criteria) this;
        }

        public Criteria andTotalPaybackAmountOfContractNotEqualTo(String value) {
            addCriterion("total_payback_amount_of_contract <>", value, "totalPaybackAmountOfContract");
            return (Criteria) this;
        }

        public Criteria andTotalPaybackAmountOfContractGreaterThan(String value) {
            addCriterion("total_payback_amount_of_contract >", value, "totalPaybackAmountOfContract");
            return (Criteria) this;
        }

        public Criteria andTotalPaybackAmountOfContractGreaterThanOrEqualTo(String value) {
            addCriterion("total_payback_amount_of_contract >=", value, "totalPaybackAmountOfContract");
            return (Criteria) this;
        }

        public Criteria andTotalPaybackAmountOfContractLessThan(String value) {
            addCriterion("total_payback_amount_of_contract <", value, "totalPaybackAmountOfContract");
            return (Criteria) this;
        }

        public Criteria andTotalPaybackAmountOfContractLessThanOrEqualTo(String value) {
            addCriterion("total_payback_amount_of_contract <=", value, "totalPaybackAmountOfContract");
            return (Criteria) this;
        }

        public Criteria andTotalPaybackAmountOfContractLike(String value) {
            addCriterion("total_payback_amount_of_contract like", value, "totalPaybackAmountOfContract");
            return (Criteria) this;
        }

        public Criteria andTotalPaybackAmountOfContractNotLike(String value) {
            addCriterion("total_payback_amount_of_contract not like", value, "totalPaybackAmountOfContract");
            return (Criteria) this;
        }

        public Criteria andTotalPaybackAmountOfContractIn(List<String> values) {
            addCriterion("total_payback_amount_of_contract in", values, "totalPaybackAmountOfContract");
            return (Criteria) this;
        }

        public Criteria andTotalPaybackAmountOfContractNotIn(List<String> values) {
            addCriterion("total_payback_amount_of_contract not in", values, "totalPaybackAmountOfContract");
            return (Criteria) this;
        }

        public Criteria andTotalPaybackAmountOfContractBetween(String value1, String value2) {
            addCriterion("total_payback_amount_of_contract between", value1, value2, "totalPaybackAmountOfContract");
            return (Criteria) this;
        }

        public Criteria andTotalPaybackAmountOfContractNotBetween(String value1, String value2) {
            addCriterion("total_payback_amount_of_contract not between", value1, value2, "totalPaybackAmountOfContract");
            return (Criteria) this;
        }

        public Criteria andMembershipInterestIsNull() {
            addCriterion("membership_interest is null");
            return (Criteria) this;
        }

        public Criteria andMembershipInterestIsNotNull() {
            addCriterion("membership_interest is not null");
            return (Criteria) this;
        }

        public Criteria andMembershipInterestEqualTo(String value) {
            addCriterion("membership_interest =", value, "membershipInterest");
            return (Criteria) this;
        }

        public Criteria andMembershipInterestNotEqualTo(String value) {
            addCriterion("membership_interest <>", value, "membershipInterest");
            return (Criteria) this;
        }

        public Criteria andMembershipInterestGreaterThan(String value) {
            addCriterion("membership_interest >", value, "membershipInterest");
            return (Criteria) this;
        }

        public Criteria andMembershipInterestGreaterThanOrEqualTo(String value) {
            addCriterion("membership_interest >=", value, "membershipInterest");
            return (Criteria) this;
        }

        public Criteria andMembershipInterestLessThan(String value) {
            addCriterion("membership_interest <", value, "membershipInterest");
            return (Criteria) this;
        }

        public Criteria andMembershipInterestLessThanOrEqualTo(String value) {
            addCriterion("membership_interest <=", value, "membershipInterest");
            return (Criteria) this;
        }

        public Criteria andMembershipInterestLike(String value) {
            addCriterion("membership_interest like", value, "membershipInterest");
            return (Criteria) this;
        }

        public Criteria andMembershipInterestNotLike(String value) {
            addCriterion("membership_interest not like", value, "membershipInterest");
            return (Criteria) this;
        }

        public Criteria andMembershipInterestIn(List<String> values) {
            addCriterion("membership_interest in", values, "membershipInterest");
            return (Criteria) this;
        }

        public Criteria andMembershipInterestNotIn(List<String> values) {
            addCriterion("membership_interest not in", values, "membershipInterest");
            return (Criteria) this;
        }

        public Criteria andMembershipInterestBetween(String value1, String value2) {
            addCriterion("membership_interest between", value1, value2, "membershipInterest");
            return (Criteria) this;
        }

        public Criteria andMembershipInterestNotBetween(String value1, String value2) {
            addCriterion("membership_interest not between", value1, value2, "membershipInterest");
            return (Criteria) this;
        }

        public Criteria andMembershipClassificationIsNull() {
            addCriterion("membership_classification is null");
            return (Criteria) this;
        }

        public Criteria andMembershipClassificationIsNotNull() {
            addCriterion("membership_classification is not null");
            return (Criteria) this;
        }

        public Criteria andMembershipClassificationEqualTo(String value) {
            addCriterion("membership_classification =", value, "membershipClassification");
            return (Criteria) this;
        }

        public Criteria andMembershipClassificationNotEqualTo(String value) {
            addCriterion("membership_classification <>", value, "membershipClassification");
            return (Criteria) this;
        }

        public Criteria andMembershipClassificationGreaterThan(String value) {
            addCriterion("membership_classification >", value, "membershipClassification");
            return (Criteria) this;
        }

        public Criteria andMembershipClassificationGreaterThanOrEqualTo(String value) {
            addCriterion("membership_classification >=", value, "membershipClassification");
            return (Criteria) this;
        }

        public Criteria andMembershipClassificationLessThan(String value) {
            addCriterion("membership_classification <", value, "membershipClassification");
            return (Criteria) this;
        }

        public Criteria andMembershipClassificationLessThanOrEqualTo(String value) {
            addCriterion("membership_classification <=", value, "membershipClassification");
            return (Criteria) this;
        }

        public Criteria andMembershipClassificationLike(String value) {
            addCriterion("membership_classification like", value, "membershipClassification");
            return (Criteria) this;
        }

        public Criteria andMembershipClassificationNotLike(String value) {
            addCriterion("membership_classification not like", value, "membershipClassification");
            return (Criteria) this;
        }

        public Criteria andMembershipClassificationIn(List<String> values) {
            addCriterion("membership_classification in", values, "membershipClassification");
            return (Criteria) this;
        }

        public Criteria andMembershipClassificationNotIn(List<String> values) {
            addCriterion("membership_classification not in", values, "membershipClassification");
            return (Criteria) this;
        }

        public Criteria andMembershipClassificationBetween(String value1, String value2) {
            addCriterion("membership_classification between", value1, value2, "membershipClassification");
            return (Criteria) this;
        }

        public Criteria andMembershipClassificationNotBetween(String value1, String value2) {
            addCriterion("membership_classification not between", value1, value2, "membershipClassification");
            return (Criteria) this;
        }

        public Criteria andCommissionDistributionStatusIsNull() {
            addCriterion("commission_distribution_status is null");
            return (Criteria) this;
        }

        public Criteria andCommissionDistributionStatusIsNotNull() {
            addCriterion("commission_distribution_status is not null");
            return (Criteria) this;
        }

        public Criteria andCommissionDistributionStatusEqualTo(String value) {
            addCriterion("commission_distribution_status =", value, "commissionDistributionStatus");
            return (Criteria) this;
        }

        public Criteria andCommissionDistributionStatusNotEqualTo(String value) {
            addCriterion("commission_distribution_status <>", value, "commissionDistributionStatus");
            return (Criteria) this;
        }

        public Criteria andCommissionDistributionStatusGreaterThan(String value) {
            addCriterion("commission_distribution_status >", value, "commissionDistributionStatus");
            return (Criteria) this;
        }

        public Criteria andCommissionDistributionStatusGreaterThanOrEqualTo(String value) {
            addCriterion("commission_distribution_status >=", value, "commissionDistributionStatus");
            return (Criteria) this;
        }

        public Criteria andCommissionDistributionStatusLessThan(String value) {
            addCriterion("commission_distribution_status <", value, "commissionDistributionStatus");
            return (Criteria) this;
        }

        public Criteria andCommissionDistributionStatusLessThanOrEqualTo(String value) {
            addCriterion("commission_distribution_status <=", value, "commissionDistributionStatus");
            return (Criteria) this;
        }

        public Criteria andCommissionDistributionStatusLike(String value) {
            addCriterion("commission_distribution_status like", value, "commissionDistributionStatus");
            return (Criteria) this;
        }

        public Criteria andCommissionDistributionStatusNotLike(String value) {
            addCriterion("commission_distribution_status not like", value, "commissionDistributionStatus");
            return (Criteria) this;
        }

        public Criteria andCommissionDistributionStatusIn(List<String> values) {
            addCriterion("commission_distribution_status in", values, "commissionDistributionStatus");
            return (Criteria) this;
        }

        public Criteria andCommissionDistributionStatusNotIn(List<String> values) {
            addCriterion("commission_distribution_status not in", values, "commissionDistributionStatus");
            return (Criteria) this;
        }

        public Criteria andCommissionDistributionStatusBetween(String value1, String value2) {
            addCriterion("commission_distribution_status between", value1, value2, "commissionDistributionStatus");
            return (Criteria) this;
        }

        public Criteria andCommissionDistributionStatusNotBetween(String value1, String value2) {
            addCriterion("commission_distribution_status not between", value1, value2, "commissionDistributionStatus");
            return (Criteria) this;
        }

        public Criteria andAdjustmentRecordIsNull() {
            addCriterion("adjustment_record is null");
            return (Criteria) this;
        }

        public Criteria andAdjustmentRecordIsNotNull() {
            addCriterion("adjustment_record is not null");
            return (Criteria) this;
        }

        public Criteria andAdjustmentRecordEqualTo(String value) {
            addCriterion("adjustment_record =", value, "adjustmentRecord");
            return (Criteria) this;
        }

        public Criteria andAdjustmentRecordNotEqualTo(String value) {
            addCriterion("adjustment_record <>", value, "adjustmentRecord");
            return (Criteria) this;
        }

        public Criteria andAdjustmentRecordGreaterThan(String value) {
            addCriterion("adjustment_record >", value, "adjustmentRecord");
            return (Criteria) this;
        }

        public Criteria andAdjustmentRecordGreaterThanOrEqualTo(String value) {
            addCriterion("adjustment_record >=", value, "adjustmentRecord");
            return (Criteria) this;
        }

        public Criteria andAdjustmentRecordLessThan(String value) {
            addCriterion("adjustment_record <", value, "adjustmentRecord");
            return (Criteria) this;
        }

        public Criteria andAdjustmentRecordLessThanOrEqualTo(String value) {
            addCriterion("adjustment_record <=", value, "adjustmentRecord");
            return (Criteria) this;
        }

        public Criteria andAdjustmentRecordLike(String value) {
            addCriterion("adjustment_record like", value, "adjustmentRecord");
            return (Criteria) this;
        }

        public Criteria andAdjustmentRecordNotLike(String value) {
            addCriterion("adjustment_record not like", value, "adjustmentRecord");
            return (Criteria) this;
        }

        public Criteria andAdjustmentRecordIn(List<String> values) {
            addCriterion("adjustment_record in", values, "adjustmentRecord");
            return (Criteria) this;
        }

        public Criteria andAdjustmentRecordNotIn(List<String> values) {
            addCriterion("adjustment_record not in", values, "adjustmentRecord");
            return (Criteria) this;
        }

        public Criteria andAdjustmentRecordBetween(String value1, String value2) {
            addCriterion("adjustment_record between", value1, value2, "adjustmentRecord");
            return (Criteria) this;
        }

        public Criteria andAdjustmentRecordNotBetween(String value1, String value2) {
            addCriterion("adjustment_record not between", value1, value2, "adjustmentRecord");
            return (Criteria) this;
        }

        public Criteria andContractCreatePeopleIsNull() {
            addCriterion("contract_create_people is null");
            return (Criteria) this;
        }

        public Criteria andContractCreatePeopleIsNotNull() {
            addCriterion("contract_create_people is not null");
            return (Criteria) this;
        }

        public Criteria andContractCreatePeopleEqualTo(String value) {
            addCriterion("contract_create_people =", value, "contractCreatePeople");
            return (Criteria) this;
        }

        public Criteria andContractCreatePeopleNotEqualTo(String value) {
            addCriterion("contract_create_people <>", value, "contractCreatePeople");
            return (Criteria) this;
        }

        public Criteria andContractCreatePeopleGreaterThan(String value) {
            addCriterion("contract_create_people >", value, "contractCreatePeople");
            return (Criteria) this;
        }

        public Criteria andContractCreatePeopleGreaterThanOrEqualTo(String value) {
            addCriterion("contract_create_people >=", value, "contractCreatePeople");
            return (Criteria) this;
        }

        public Criteria andContractCreatePeopleLessThan(String value) {
            addCriterion("contract_create_people <", value, "contractCreatePeople");
            return (Criteria) this;
        }

        public Criteria andContractCreatePeopleLessThanOrEqualTo(String value) {
            addCriterion("contract_create_people <=", value, "contractCreatePeople");
            return (Criteria) this;
        }

        public Criteria andContractCreatePeopleLike(String value) {
            addCriterion("contract_create_people like", value, "contractCreatePeople");
            return (Criteria) this;
        }

        public Criteria andContractCreatePeopleNotLike(String value) {
            addCriterion("contract_create_people not like", value, "contractCreatePeople");
            return (Criteria) this;
        }

        public Criteria andContractCreatePeopleIn(List<String> values) {
            addCriterion("contract_create_people in", values, "contractCreatePeople");
            return (Criteria) this;
        }

        public Criteria andContractCreatePeopleNotIn(List<String> values) {
            addCriterion("contract_create_people not in", values, "contractCreatePeople");
            return (Criteria) this;
        }

        public Criteria andContractCreatePeopleBetween(String value1, String value2) {
            addCriterion("contract_create_people between", value1, value2, "contractCreatePeople");
            return (Criteria) this;
        }

        public Criteria andContractCreatePeopleNotBetween(String value1, String value2) {
            addCriterion("contract_create_people not between", value1, value2, "contractCreatePeople");
            return (Criteria) this;
        }

        public Criteria andContractUpdateTimeIsNull() {
            addCriterion("contract_update_time is null");
            return (Criteria) this;
        }

        public Criteria andContractUpdateTimeIsNotNull() {
            addCriterion("contract_update_time is not null");
            return (Criteria) this;
        }

        public Criteria andContractUpdateTimeEqualTo(String value) {
            addCriterion("contract_update_time =", value, "contractUpdateTime");
            return (Criteria) this;
        }

        public Criteria andContractUpdateTimeNotEqualTo(String value) {
            addCriterion("contract_update_time <>", value, "contractUpdateTime");
            return (Criteria) this;
        }

        public Criteria andContractUpdateTimeGreaterThan(String value) {
            addCriterion("contract_update_time >", value, "contractUpdateTime");
            return (Criteria) this;
        }

        public Criteria andContractUpdateTimeGreaterThanOrEqualTo(String value) {
            addCriterion("contract_update_time >=", value, "contractUpdateTime");
            return (Criteria) this;
        }

        public Criteria andContractUpdateTimeLessThan(String value) {
            addCriterion("contract_update_time <", value, "contractUpdateTime");
            return (Criteria) this;
        }

        public Criteria andContractUpdateTimeLessThanOrEqualTo(String value) {
            addCriterion("contract_update_time <=", value, "contractUpdateTime");
            return (Criteria) this;
        }

        public Criteria andContractUpdateTimeLike(String value) {
            addCriterion("contract_update_time like", value, "contractUpdateTime");
            return (Criteria) this;
        }

        public Criteria andContractUpdateTimeNotLike(String value) {
            addCriterion("contract_update_time not like", value, "contractUpdateTime");
            return (Criteria) this;
        }

        public Criteria andContractUpdateTimeIn(List<String> values) {
            addCriterion("contract_update_time in", values, "contractUpdateTime");
            return (Criteria) this;
        }

        public Criteria andContractUpdateTimeNotIn(List<String> values) {
            addCriterion("contract_update_time not in", values, "contractUpdateTime");
            return (Criteria) this;
        }

        public Criteria andContractUpdateTimeBetween(String value1, String value2) {
            addCriterion("contract_update_time between", value1, value2, "contractUpdateTime");
            return (Criteria) this;
        }

        public Criteria andContractUpdateTimeNotBetween(String value1, String value2) {
            addCriterion("contract_update_time not between", value1, value2, "contractUpdateTime");
            return (Criteria) this;
        }

        public Criteria andContractUpdatePeopleIsNull() {
            addCriterion("contract_update_people is null");
            return (Criteria) this;
        }

        public Criteria andContractUpdatePeopleIsNotNull() {
            addCriterion("contract_update_people is not null");
            return (Criteria) this;
        }

        public Criteria andContractUpdatePeopleEqualTo(String value) {
            addCriterion("contract_update_people =", value, "contractUpdatePeople");
            return (Criteria) this;
        }

        public Criteria andContractUpdatePeopleNotEqualTo(String value) {
            addCriterion("contract_update_people <>", value, "contractUpdatePeople");
            return (Criteria) this;
        }

        public Criteria andContractUpdatePeopleGreaterThan(String value) {
            addCriterion("contract_update_people >", value, "contractUpdatePeople");
            return (Criteria) this;
        }

        public Criteria andContractUpdatePeopleGreaterThanOrEqualTo(String value) {
            addCriterion("contract_update_people >=", value, "contractUpdatePeople");
            return (Criteria) this;
        }

        public Criteria andContractUpdatePeopleLessThan(String value) {
            addCriterion("contract_update_people <", value, "contractUpdatePeople");
            return (Criteria) this;
        }

        public Criteria andContractUpdatePeopleLessThanOrEqualTo(String value) {
            addCriterion("contract_update_people <=", value, "contractUpdatePeople");
            return (Criteria) this;
        }

        public Criteria andContractUpdatePeopleLike(String value) {
            addCriterion("contract_update_people like", value, "contractUpdatePeople");
            return (Criteria) this;
        }

        public Criteria andContractUpdatePeopleNotLike(String value) {
            addCriterion("contract_update_people not like", value, "contractUpdatePeople");
            return (Criteria) this;
        }

        public Criteria andContractUpdatePeopleIn(List<String> values) {
            addCriterion("contract_update_people in", values, "contractUpdatePeople");
            return (Criteria) this;
        }

        public Criteria andContractUpdatePeopleNotIn(List<String> values) {
            addCriterion("contract_update_people not in", values, "contractUpdatePeople");
            return (Criteria) this;
        }

        public Criteria andContractUpdatePeopleBetween(String value1, String value2) {
            addCriterion("contract_update_people between", value1, value2, "contractUpdatePeople");
            return (Criteria) this;
        }

        public Criteria andContractUpdatePeopleNotBetween(String value1, String value2) {
            addCriterion("contract_update_people not between", value1, value2, "contractUpdatePeople");
            return (Criteria) this;
        }

        public Criteria andMembershipCardOrderIsNull() {
            addCriterion("membership_card_order is null");
            return (Criteria) this;
        }

        public Criteria andMembershipCardOrderIsNotNull() {
            addCriterion("membership_card_order is not null");
            return (Criteria) this;
        }

        public Criteria andMembershipCardOrderEqualTo(String value) {
            addCriterion("membership_card_order =", value, "membershipCardOrder");
            return (Criteria) this;
        }

        public Criteria andMembershipCardOrderNotEqualTo(String value) {
            addCriterion("membership_card_order <>", value, "membershipCardOrder");
            return (Criteria) this;
        }

        public Criteria andMembershipCardOrderGreaterThan(String value) {
            addCriterion("membership_card_order >", value, "membershipCardOrder");
            return (Criteria) this;
        }

        public Criteria andMembershipCardOrderGreaterThanOrEqualTo(String value) {
            addCriterion("membership_card_order >=", value, "membershipCardOrder");
            return (Criteria) this;
        }

        public Criteria andMembershipCardOrderLessThan(String value) {
            addCriterion("membership_card_order <", value, "membershipCardOrder");
            return (Criteria) this;
        }

        public Criteria andMembershipCardOrderLessThanOrEqualTo(String value) {
            addCriterion("membership_card_order <=", value, "membershipCardOrder");
            return (Criteria) this;
        }

        public Criteria andMembershipCardOrderLike(String value) {
            addCriterion("membership_card_order like", value, "membershipCardOrder");
            return (Criteria) this;
        }

        public Criteria andMembershipCardOrderNotLike(String value) {
            addCriterion("membership_card_order not like", value, "membershipCardOrder");
            return (Criteria) this;
        }

        public Criteria andMembershipCardOrderIn(List<String> values) {
            addCriterion("membership_card_order in", values, "membershipCardOrder");
            return (Criteria) this;
        }

        public Criteria andMembershipCardOrderNotIn(List<String> values) {
            addCriterion("membership_card_order not in", values, "membershipCardOrder");
            return (Criteria) this;
        }

        public Criteria andMembershipCardOrderBetween(String value1, String value2) {
            addCriterion("membership_card_order between", value1, value2, "membershipCardOrder");
            return (Criteria) this;
        }

        public Criteria andMembershipCardOrderNotBetween(String value1, String value2) {
            addCriterion("membership_card_order not between", value1, value2, "membershipCardOrder");
            return (Criteria) this;
        }

        public Criteria andMembershipCardLevelIsNull() {
            addCriterion("membership_card_level is null");
            return (Criteria) this;
        }

        public Criteria andMembershipCardLevelIsNotNull() {
            addCriterion("membership_card_level is not null");
            return (Criteria) this;
        }

        public Criteria andMembershipCardLevelEqualTo(String value) {
            addCriterion("membership_card_level =", value, "membershipCardLevel");
            return (Criteria) this;
        }

        public Criteria andMembershipCardLevelNotEqualTo(String value) {
            addCriterion("membership_card_level <>", value, "membershipCardLevel");
            return (Criteria) this;
        }

        public Criteria andMembershipCardLevelGreaterThan(String value) {
            addCriterion("membership_card_level >", value, "membershipCardLevel");
            return (Criteria) this;
        }

        public Criteria andMembershipCardLevelGreaterThanOrEqualTo(String value) {
            addCriterion("membership_card_level >=", value, "membershipCardLevel");
            return (Criteria) this;
        }

        public Criteria andMembershipCardLevelLessThan(String value) {
            addCriterion("membership_card_level <", value, "membershipCardLevel");
            return (Criteria) this;
        }

        public Criteria andMembershipCardLevelLessThanOrEqualTo(String value) {
            addCriterion("membership_card_level <=", value, "membershipCardLevel");
            return (Criteria) this;
        }

        public Criteria andMembershipCardLevelLike(String value) {
            addCriterion("membership_card_level like", value, "membershipCardLevel");
            return (Criteria) this;
        }

        public Criteria andMembershipCardLevelNotLike(String value) {
            addCriterion("membership_card_level not like", value, "membershipCardLevel");
            return (Criteria) this;
        }

        public Criteria andMembershipCardLevelIn(List<String> values) {
            addCriterion("membership_card_level in", values, "membershipCardLevel");
            return (Criteria) this;
        }

        public Criteria andMembershipCardLevelNotIn(List<String> values) {
            addCriterion("membership_card_level not in", values, "membershipCardLevel");
            return (Criteria) this;
        }

        public Criteria andMembershipCardLevelBetween(String value1, String value2) {
            addCriterion("membership_card_level between", value1, value2, "membershipCardLevel");
            return (Criteria) this;
        }

        public Criteria andMembershipCardLevelNotBetween(String value1, String value2) {
            addCriterion("membership_card_level not between", value1, value2, "membershipCardLevel");
            return (Criteria) this;
        }

        public Criteria andOrderQuantityStatisticsIsNull() {
            addCriterion("order_quantity_statistics is null");
            return (Criteria) this;
        }

        public Criteria andOrderQuantityStatisticsIsNotNull() {
            addCriterion("order_quantity_statistics is not null");
            return (Criteria) this;
        }

        public Criteria andOrderQuantityStatisticsEqualTo(String value) {
            addCriterion("order_quantity_statistics =", value, "orderQuantityStatistics");
            return (Criteria) this;
        }

        public Criteria andOrderQuantityStatisticsNotEqualTo(String value) {
            addCriterion("order_quantity_statistics <>", value, "orderQuantityStatistics");
            return (Criteria) this;
        }

        public Criteria andOrderQuantityStatisticsGreaterThan(String value) {
            addCriterion("order_quantity_statistics >", value, "orderQuantityStatistics");
            return (Criteria) this;
        }

        public Criteria andOrderQuantityStatisticsGreaterThanOrEqualTo(String value) {
            addCriterion("order_quantity_statistics >=", value, "orderQuantityStatistics");
            return (Criteria) this;
        }

        public Criteria andOrderQuantityStatisticsLessThan(String value) {
            addCriterion("order_quantity_statistics <", value, "orderQuantityStatistics");
            return (Criteria) this;
        }

        public Criteria andOrderQuantityStatisticsLessThanOrEqualTo(String value) {
            addCriterion("order_quantity_statistics <=", value, "orderQuantityStatistics");
            return (Criteria) this;
        }

        public Criteria andOrderQuantityStatisticsLike(String value) {
            addCriterion("order_quantity_statistics like", value, "orderQuantityStatistics");
            return (Criteria) this;
        }

        public Criteria andOrderQuantityStatisticsNotLike(String value) {
            addCriterion("order_quantity_statistics not like", value, "orderQuantityStatistics");
            return (Criteria) this;
        }

        public Criteria andOrderQuantityStatisticsIn(List<String> values) {
            addCriterion("order_quantity_statistics in", values, "orderQuantityStatistics");
            return (Criteria) this;
        }

        public Criteria andOrderQuantityStatisticsNotIn(List<String> values) {
            addCriterion("order_quantity_statistics not in", values, "orderQuantityStatistics");
            return (Criteria) this;
        }

        public Criteria andOrderQuantityStatisticsBetween(String value1, String value2) {
            addCriterion("order_quantity_statistics between", value1, value2, "orderQuantityStatistics");
            return (Criteria) this;
        }

        public Criteria andOrderQuantityStatisticsNotBetween(String value1, String value2) {
            addCriterion("order_quantity_statistics not between", value1, value2, "orderQuantityStatistics");
            return (Criteria) this;
        }

        public Criteria andCreatePeopleIdIsNull() {
            addCriterion("create_people_id is null");
            return (Criteria) this;
        }

        public Criteria andCreatePeopleIdIsNotNull() {
            addCriterion("create_people_id is not null");
            return (Criteria) this;
        }

        public Criteria andCreatePeopleIdEqualTo(String value) {
            addCriterion("create_people_id =", value, "createPeopleId");
            return (Criteria) this;
        }

        public Criteria andCreatePeopleIdNotEqualTo(String value) {
            addCriterion("create_people_id <>", value, "createPeopleId");
            return (Criteria) this;
        }

        public Criteria andCreatePeopleIdGreaterThan(String value) {
            addCriterion("create_people_id >", value, "createPeopleId");
            return (Criteria) this;
        }

        public Criteria andCreatePeopleIdGreaterThanOrEqualTo(String value) {
            addCriterion("create_people_id >=", value, "createPeopleId");
            return (Criteria) this;
        }

        public Criteria andCreatePeopleIdLessThan(String value) {
            addCriterion("create_people_id <", value, "createPeopleId");
            return (Criteria) this;
        }

        public Criteria andCreatePeopleIdLessThanOrEqualTo(String value) {
            addCriterion("create_people_id <=", value, "createPeopleId");
            return (Criteria) this;
        }

        public Criteria andCreatePeopleIdLike(String value) {
            addCriterion("create_people_id like", value, "createPeopleId");
            return (Criteria) this;
        }

        public Criteria andCreatePeopleIdNotLike(String value) {
            addCriterion("create_people_id not like", value, "createPeopleId");
            return (Criteria) this;
        }

        public Criteria andCreatePeopleIdIn(List<String> values) {
            addCriterion("create_people_id in", values, "createPeopleId");
            return (Criteria) this;
        }

        public Criteria andCreatePeopleIdNotIn(List<String> values) {
            addCriterion("create_people_id not in", values, "createPeopleId");
            return (Criteria) this;
        }

        public Criteria andCreatePeopleIdBetween(String value1, String value2) {
            addCriterion("create_people_id between", value1, value2, "createPeopleId");
            return (Criteria) this;
        }

        public Criteria andCreatePeopleIdNotBetween(String value1, String value2) {
            addCriterion("create_people_id not between", value1, value2, "createPeopleId");
            return (Criteria) this;
        }

        public Criteria andCreateTmIsNull() {
            addCriterion("create_tm is null");
            return (Criteria) this;
        }

        public Criteria andCreateTmIsNotNull() {
            addCriterion("create_tm is not null");
            return (Criteria) this;
        }

        public Criteria andCreateTmEqualTo(Date value) {
            addCriterion("create_tm =", value, "createTm");
            return (Criteria) this;
        }

        public Criteria andCreateTmNotEqualTo(Date value) {
            addCriterion("create_tm <>", value, "createTm");
            return (Criteria) this;
        }

        public Criteria andCreateTmGreaterThan(Date value) {
            addCriterion("create_tm >", value, "createTm");
            return (Criteria) this;
        }

        public Criteria andCreateTmGreaterThanOrEqualTo(Date value) {
            addCriterion("create_tm >=", value, "createTm");
            return (Criteria) this;
        }

        public Criteria andCreateTmLessThan(Date value) {
            addCriterion("create_tm <", value, "createTm");
            return (Criteria) this;
        }

        public Criteria andCreateTmLessThanOrEqualTo(Date value) {
            addCriterion("create_tm <=", value, "createTm");
            return (Criteria) this;
        }

        public Criteria andCreateTmIn(List<Date> values) {
            addCriterion("create_tm in", values, "createTm");
            return (Criteria) this;
        }

        public Criteria andCreateTmNotIn(List<Date> values) {
            addCriterion("create_tm not in", values, "createTm");
            return (Criteria) this;
        }

        public Criteria andCreateTmBetween(Date value1, Date value2) {
            addCriterion("create_tm between", value1, value2, "createTm");
            return (Criteria) this;
        }

        public Criteria andCreateTmNotBetween(Date value1, Date value2) {
            addCriterion("create_tm not between", value1, value2, "createTm");
            return (Criteria) this;
        }

        public Criteria andUpdatePeopleIdIsNull() {
            addCriterion("update_people_id is null");
            return (Criteria) this;
        }

        public Criteria andUpdatePeopleIdIsNotNull() {
            addCriterion("update_people_id is not null");
            return (Criteria) this;
        }

        public Criteria andUpdatePeopleIdEqualTo(String value) {
            addCriterion("update_people_id =", value, "updatePeopleId");
            return (Criteria) this;
        }

        public Criteria andUpdatePeopleIdNotEqualTo(String value) {
            addCriterion("update_people_id <>", value, "updatePeopleId");
            return (Criteria) this;
        }

        public Criteria andUpdatePeopleIdGreaterThan(String value) {
            addCriterion("update_people_id >", value, "updatePeopleId");
            return (Criteria) this;
        }

        public Criteria andUpdatePeopleIdGreaterThanOrEqualTo(String value) {
            addCriterion("update_people_id >=", value, "updatePeopleId");
            return (Criteria) this;
        }

        public Criteria andUpdatePeopleIdLessThan(String value) {
            addCriterion("update_people_id <", value, "updatePeopleId");
            return (Criteria) this;
        }

        public Criteria andUpdatePeopleIdLessThanOrEqualTo(String value) {
            addCriterion("update_people_id <=", value, "updatePeopleId");
            return (Criteria) this;
        }

        public Criteria andUpdatePeopleIdLike(String value) {
            addCriterion("update_people_id like", value, "updatePeopleId");
            return (Criteria) this;
        }

        public Criteria andUpdatePeopleIdNotLike(String value) {
            addCriterion("update_people_id not like", value, "updatePeopleId");
            return (Criteria) this;
        }

        public Criteria andUpdatePeopleIdIn(List<String> values) {
            addCriterion("update_people_id in", values, "updatePeopleId");
            return (Criteria) this;
        }

        public Criteria andUpdatePeopleIdNotIn(List<String> values) {
            addCriterion("update_people_id not in", values, "updatePeopleId");
            return (Criteria) this;
        }

        public Criteria andUpdatePeopleIdBetween(String value1, String value2) {
            addCriterion("update_people_id between", value1, value2, "updatePeopleId");
            return (Criteria) this;
        }

        public Criteria andUpdatePeopleIdNotBetween(String value1, String value2) {
            addCriterion("update_people_id not between", value1, value2, "updatePeopleId");
            return (Criteria) this;
        }

        public Criteria andUpdateTmIsNull() {
            addCriterion("update_tm is null");
            return (Criteria) this;
        }

        public Criteria andUpdateTmIsNotNull() {
            addCriterion("update_tm is not null");
            return (Criteria) this;
        }

        public Criteria andUpdateTmEqualTo(Date value) {
            addCriterion("update_tm =", value, "updateTm");
            return (Criteria) this;
        }

        public Criteria andUpdateTmNotEqualTo(Date value) {
            addCriterion("update_tm <>", value, "updateTm");
            return (Criteria) this;
        }

        public Criteria andUpdateTmGreaterThan(Date value) {
            addCriterion("update_tm >", value, "updateTm");
            return (Criteria) this;
        }

        public Criteria andUpdateTmGreaterThanOrEqualTo(Date value) {
            addCriterion("update_tm >=", value, "updateTm");
            return (Criteria) this;
        }

        public Criteria andUpdateTmLessThan(Date value) {
            addCriterion("update_tm <", value, "updateTm");
            return (Criteria) this;
        }

        public Criteria andUpdateTmLessThanOrEqualTo(Date value) {
            addCriterion("update_tm <=", value, "updateTm");
            return (Criteria) this;
        }

        public Criteria andUpdateTmIn(List<Date> values) {
            addCriterion("update_tm in", values, "updateTm");
            return (Criteria) this;
        }

        public Criteria andUpdateTmNotIn(List<Date> values) {
            addCriterion("update_tm not in", values, "updateTm");
            return (Criteria) this;
        }

        public Criteria andUpdateTmBetween(Date value1, Date value2) {
            addCriterion("update_tm between", value1, value2, "updateTm");
            return (Criteria) this;
        }

        public Criteria andUpdateTmNotBetween(Date value1, Date value2) {
            addCriterion("update_tm not between", value1, value2, "updateTm");
            return (Criteria) this;
        }

        public Criteria andDeleteStatusIsNull() {
            addCriterion("delete_status is null");
            return (Criteria) this;
        }

        public Criteria andDeleteStatusIsNotNull() {
            addCriterion("delete_status is not null");
            return (Criteria) this;
        }

        public Criteria andDeleteStatusEqualTo(Short value) {
            addCriterion("delete_status =", value, "deleteStatus");
            return (Criteria) this;
        }

        public Criteria andDeleteStatusNotEqualTo(Short value) {
            addCriterion("delete_status <>", value, "deleteStatus");
            return (Criteria) this;
        }

        public Criteria andDeleteStatusGreaterThan(Short value) {
            addCriterion("delete_status >", value, "deleteStatus");
            return (Criteria) this;
        }

        public Criteria andDeleteStatusGreaterThanOrEqualTo(Short value) {
            addCriterion("delete_status >=", value, "deleteStatus");
            return (Criteria) this;
        }

        public Criteria andDeleteStatusLessThan(Short value) {
            addCriterion("delete_status <", value, "deleteStatus");
            return (Criteria) this;
        }

        public Criteria andDeleteStatusLessThanOrEqualTo(Short value) {
            addCriterion("delete_status <=", value, "deleteStatus");
            return (Criteria) this;
        }

        public Criteria andDeleteStatusIn(List<Short> values) {
            addCriterion("delete_status in", values, "deleteStatus");
            return (Criteria) this;
        }

        public Criteria andDeleteStatusNotIn(List<Short> values) {
            addCriterion("delete_status not in", values, "deleteStatus");
            return (Criteria) this;
        }

        public Criteria andDeleteStatusBetween(Short value1, Short value2) {
            addCriterion("delete_status between", value1, value2, "deleteStatus");
            return (Criteria) this;
        }

        public Criteria andDeleteStatusNotBetween(Short value1, Short value2) {
            addCriterion("delete_status not between", value1, value2, "deleteStatus");
            return (Criteria) this;
        }
    }

    public static class Criteria extends GeneratedCriteria {
        protected Criteria() {
            super();
        }
    }

    public static class Criterion {
        private String condition;

        private Object value;

        private Object secondValue;

        private boolean noValue;

        private boolean singleValue;

        private boolean betweenValue;

        private boolean listValue;

        private String typeHandler;

        public String getCondition() {
            return condition;
        }

        public Object getValue() {
            return value;
        }

        public Object getSecondValue() {
            return secondValue;
        }

        public boolean isNoValue() {
            return noValue;
        }

        public boolean isSingleValue() {
            return singleValue;
        }

        public boolean isBetweenValue() {
            return betweenValue;
        }

        public boolean isListValue() {
            return listValue;
        }

        public String getTypeHandler() {
            return typeHandler;
        }

        protected Criterion(String condition) {
            super();
            this.condition = condition;
            this.typeHandler = null;
            this.noValue = true;
        }

        protected Criterion(String condition, Object value, String typeHandler) {
            super();
            this.condition = condition;
            this.value = value;
            this.typeHandler = typeHandler;
            if (value instanceof List<?>) {
                this.listValue = true;
            } else {
                this.singleValue = true;
            }
        }

        protected Criterion(String condition, Object value) {
            this(condition, value, null);
        }

        protected Criterion(String condition, Object value, Object secondValue, String typeHandler) {
            super();
            this.condition = condition;
            this.value = value;
            this.secondValue = secondValue;
            this.typeHandler = typeHandler;
            this.betweenValue = true;
        }

        protected Criterion(String condition, Object value, Object secondValue) {
            this(condition, value, secondValue, null);
        }
    }
}